It appears you have not yet registered with DEVPPL. To register please click here... (it's fast, easy and free!)

Forum

Log In Sponsors
Board index Programming PHP and MySQL Forum

Why is my search feature running slow???

Moderator: Malcolm

Why is my search feature running slow???

Postby tworedballs on Wed Nov 11, 2009 4:10 pm

Every now and then I use the search tool on my site and it runs VERY slowly. Takes nearly 2 minutes to complete a search. It was built in php by a company we hired, but have since moved away from them.

The script they used is called PHPSiteSearch v1.7.7

Any ideas? More info needed? :?
tworedballs
 
Posts: 3
Joined: Tue Sep 05, 2006 5:33 pm
Location: Central Florida

Re: Why is my search feature running slow???

Postby dflynn on Tue Dec 29, 2009 5:00 am

Do you have any insight to how data is being stored on your site?

PHPSiteSearch v1.7.7 utilizes a flat file database system, essentially storing content int text files and using php to open and search through those files for search terms.

This method is intended for small - medium sized sites. You definitely wouldn't utilize this for something like Amazon or Facebook, but a blog or a small company with a few products would work well.

Flat files aren't exactly the quickest way to access information, and the more content it has to search through the more time it will take.
User avatar
dflynn
500+ Club
 
Posts: 860
Joined: Wed Oct 03, 2007 9:06 pm
Location: Guelph, Canada


Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest