Jump to content

Archived

This topic is now archived and is closed to further replies.

w4seem

coding or server???

Recommended Posts

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...

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
Have you put indexes on the columns you are searching? That will make a big difference.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.