w4seem Posted July 26, 2006 Share Posted July 26, 2006 hi all,im struggling to find out whether it is the coding or the server which is slowing my site down.whenever i search for anything on the database it seems to run slow, but im informed that the coding is not the problem?is there anyway i can check to see what is causing the slow down??im new to this so basic explantion would be helpful.the site is... Link to comment https://forums.phpfreaks.com/topic/15723-coding-or-server/ Share on other sites More sharing options...
w4seem Posted July 26, 2006 Author Share Posted July 26, 2006 www.studyleave.comits basically a book shop.thanks Link to comment https://forums.phpfreaks.com/topic/15723-coding-or-server/#findComment-64232 Share on other sites More sharing options...
wildteen88 Posted July 26, 2006 Share Posted July 26, 2006 Does it only slow down when you are searching the database? If thats the case you might want to try and optimize your query, or normalize your database. Link to comment https://forums.phpfreaks.com/topic/15723-coding-or-server/#findComment-64237 Share on other sites More sharing options...
king arthur Posted July 26, 2006 Share Posted July 26, 2006 Have you put indexes on the columns you are searching? That will make a big difference. Link to comment https://forums.phpfreaks.com/topic/15723-coding-or-server/#findComment-64289 Share on other sites More sharing options...
w4seem Posted July 27, 2006 Author Share Posted July 27, 2006 Indeed the slowdown is only present when you search for something in the database.The database file is originally a txt file which is couple around 250 megabytes (around 500,000 book titles, price, isbn, description etc)also indexes are in place, im not sure how to optimize my query?please help. Link to comment https://forums.phpfreaks.com/topic/15723-coding-or-server/#findComment-64587 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.