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... Quote 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 Quote 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. Quote 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. Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/15723-coding-or-server/#findComment-64587 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.