My first post ever. I maintain a fairly large directory. Lately, it seems like my search results are taking longer and longer to load. Is it because of the way the data base is structured or is it in some way related to the server? DrycleanersRelief.com

Thanks for any input.
Dan

What kind of database is it and what kind of searching do you do on it?

You site has a major design problem. Verything is overlapping one another. There is just too many things going on it the page. Simple is better........ Anyways you directory is very slow.

Originally Posted by cptnwinky

What kind of database is it and what kind of searching do you do on it?

Its MySQL...a data base for locating drycleaners in your local area.

Originally Posted by mohamoud

You site has a major design problem. Verything is overlapping one another. There is just too many things going on it the page. Simple is better........ Anyways you directory is very slow.

What is overlapping?????????????? I know its become slow....so, thats why Im here.

With mysql you have a couple different options. You can use the LIKE clause...

SELECT * FROM mytable WHERE mycolumn LIKE value

Or you can use the much preffered way as of 4.0.1+ which is full text searching which I outline in this thread...

http://webmaster-talk.com/showthread...text+searching

If you need any more help let me know.

For a large site, I'd recommend reading this guide:
http://dev.mysql.com/books/hpmysql-excerpts/ch06.html

It's MySQL's guide to High Performance Server Tuning.

You know what, nevermind what I had said before. I was thinking of another post that was similiar to this one when I posted it. Use what desertland suggests instead.