AMD Processor s very slow for huge applications like database

deepika thota

Commendable
Sep 12, 2016
4
0
1,510
Hi,

I bought HP Laptop with AMD Processor(AMD A8-7410),4GB SODIMM DDR3 1600 MHz clocked @ 800 MHz,Memory- Samsung M471B5173E B0-YK0 1x4GB.

but as per business requirement, i have installed database server(300+GB) Oracle Apps R12. Now the lappy is very slow and laggy . The performance is terribly poor. it is taking hours even to close an app. user benchmark stating that pc is performing as expected (45th percentile). what is the alternate solution for this? how do i increase the performance of pc. Is there any possibility of swaping the cpu or processor to intel. can any one please suggest??

The User bench mark results as below-
Status:
Overall this PC is performing as expected (45th percentile). This means that out of 100 PCs with exactly the same components, 56 performed better.
Processor:
With a relatively low single core score, this CPU can handle email, light web browsing and basic audio/video playback, but it will struggle to handle CPU intensive tasks. Finally, with a gaming score of 27.9%, this CPUs suitability for 3D gaming is poor.
Graphics:
3.99% is too low to play 3D games or use CAD packages. (Note: general computing tasks don't require 3D graphics)
Boot Drive:
The boot partition is located on a mechanical or hybrid drive. Moving the system to an SSD will yield far faster boot times, better system responsiveness and faster application load times.
Memory:
4GB is enough RAM to run any version of Windows and although it's sufficient for most games, some will benefit from up to 8GB of RAM. 4GB is also enough for modest file and system caches which allow for a responsive system.
OS Version:
Windows 10 is the most recent version of windows, and the best to date in our opinion.


 
Solution
While upgrading the RAM and installing a SSD can help, the bottleneck is still the A8-7410 which is only about as powerful as a core i3-4010u (1.7GHz) CPU.

AMD APUs have very low IPC (instructions per cycle) performance compared to Intel CPUs. AMD APUs processes few instructions per Hz than an Intel CPU which is why they are considered weak processors.

For a 300GB+ database I actually recommend you buy a laptop with a quad core Intel CPU such as the HP Pavilion Laptop - 15t which has a quad core i5-6300HQ CPU in it's default configuration for $630. For such a large database, I believe you would benefit having 16GB of RAM. But that would increase the cost by $140. That is also assuming you can afford to buy a new laptop to begin with...

Autocrat

Respectable
Sep 19, 2016
505
0
2,360
Databases can be very demanding. Unfortunately the computer you have is not a very good workstation. The processor is towards the lower end, and you don't have much RAM either.

What model laptop do you have?
 

COLGeek

Cybernaut
Moderator

Agreed. This low-end laptop processor, combined with only 4GB of memory, is the problem. This system is just not suitable for the intended use.

Increasing the memory to 8GB will help slightly, but not make the CPU any stronger. You really need a more capable system to handle the desired processing load.
 

TJ Hooker

Titan
Ambassador

You definitely can't swap to an Intel CPU. The CPU is likely soldered to the motherboard, so you can't upgrade to a different AMD CPU either. Probably the only thing you could do would be to add more RAM.

At the end of the day, you pretty much just bought the wrong laptop. That laptop sounds like a budget, entry level system, and you're trying to run what sounds like a fairly demanding application on it. The results aren't surprising.
 
300 GB database on a low end laptop? Not the best thing here, about as efficient as using a straw to drain a swimming pool. You would want an Intel i7 desktop CPU with a fast hard drive and 16-32 GB of RAM to run anything that large without wondering why it's so slow.
 
While upgrading the RAM and installing a SSD can help, the bottleneck is still the A8-7410 which is only about as powerful as a core i3-4010u (1.7GHz) CPU.

AMD APUs have very low IPC (instructions per cycle) performance compared to Intel CPUs. AMD APUs processes few instructions per Hz than an Intel CPU which is why they are considered weak processors.

For a 300GB+ database I actually recommend you buy a laptop with a quad core Intel CPU such as the HP Pavilion Laptop - 15t which has a quad core i5-6300HQ CPU in it's default configuration for $630. For such a large database, I believe you would benefit having 16GB of RAM. But that would increase the cost by $140. That is also assuming you can afford to buy a new laptop to begin with.

http://store.hp.com/us/en/pdp/Laptops/hp-pavilion---15t-laptop-%28touch-option-available%29-t9y85av-1
 
Solution

bmacsys

Honorable
BANNED


What you want to do is akin to digging a swimming pool with a spoon.