The reason adding more memory was the most effective upgrade was because system was paging/swapping to hard disk - meaning the software running required more memory than the system previously had. It had to write data to your disk temporary to make space in memory.
Now that you are going to be adding enough memory (8 gig) for the program, most, if not all of the program will run in memory. Now the bottle neck will be how fast CPU can access all that memory. That's when number of CPU cores and amount of cache is going to start making difference. That's a whole different ball game than memory bound systems.
I'm not going to discourage you from going to Celeron E3500, if that is a better cpu than what you currently use. But, if you are going to do that, please do understand, that cpu will now be the limiting factor. By going with better CPU, more cache and core, will improve performance.
That said, there is no limit to "add this and upgrade this - and get better performance" game. There's always better, so you have to draw a line somewhere. I just wanted to add this because Celeron may have two cores but there is a reason why it's Celeron - lower grade CPU on Intel's line-up.
Cache on board buffers data transfer between relatively slow memory and fast cpu. It prevents CPU from waiting on memory to finish writing and some cases, reading. While it can not do magic, it does help greatly especially in heavy data manipulation tasks, like image editing.
Now that you are going to be adding enough memory (8 gig) for the program, most, if not all of the program will run in memory. Now the bottle neck will be how fast CPU can access all that memory. That's when number of CPU cores and amount of cache is going to start making difference. That's a whole different ball game than memory bound systems.
I'm not going to discourage you from going to Celeron E3500, if that is a better cpu than what you currently use. But, if you are going to do that, please do understand, that cpu will now be the limiting factor. By going with better CPU, more cache and core, will improve performance.
That said, there is no limit to "add this and upgrade this - and get better performance" game. There's always better, so you have to draw a line somewhere. I just wanted to add this because Celeron may have two cores but there is a reason why it's Celeron - lower grade CPU on Intel's line-up.
Cache on board buffers data transfer between relatively slow memory and fast cpu. It prevents CPU from waiting on memory to finish writing and some cases, reading. While it can not do magic, it does help greatly especially in heavy data manipulation tasks, like image editing.
