| Page loads super duper slow [resolved] |
[eluser]tinawina[/eluser]
Hello all - just in case this helps anyone thought I'd post the actual solution to my slow loading app problem. The answer ended up being MySQL database table (using phpMyAdmin's "optimize" option) and query optimization and, most importantly, correctly indexing my tables! That alone changed my query run-time from anywhere between 13 and 20 agonizing seconds to somewhere around .003 seconds. No joke. More good info on indexing is available in this article which really cleared up some stuff for me - hope it helps someone else: Database Journal Article. That's it! |
| Messages In This Thread |
|
Page loads super duper slow [resolved] - by El Forum - 09-25-2008, 02:14 PM
Page loads super duper slow [resolved] - by El Forum - 09-25-2008, 06:22 PM
Page loads super duper slow [resolved] - by El Forum - 09-26-2008, 01:53 PM
Page loads super duper slow [resolved] - by El Forum - 09-26-2008, 02:12 PM
Page loads super duper slow [resolved] - by El Forum - 09-26-2008, 04:35 PM
Page loads super duper slow [resolved] - by El Forum - 10-30-2008, 11:06 AM
|
