database problem?

Support issues for DGS Search

Moderator: DGS Search Developer

database problem?

Postby gellnsh » Fri Feb 24, 2012 11:05 pm

Hello, I have been having a problem with my hosting service shutting down my database because my dgs search script is taking too long to make queries. I'm wondering if there is something I can do in the config file that would limit the search to just few seconds? I'd really appreciate some help on this as I love the search engine and don't want to have to change to something else??

thanks
gellnsh
 
Posts: 2
Joined: Wed Sep 23, 2009 1:21 am

Re: database problem?

Postby sella » Fri Oct 24, 2014 10:35 pm

If you're performing queries against a database, you'll need to identify how to improve the SQL query (see the EXPLAIN command in MySQL). If this is a filesystem search, there isn't much that can be done without a full rewrite since we're bound by PHPs speed at processing the files.
User avatar
sella
Site Admin
 
Posts: 81
Joined: Sat Jan 17, 2004 6:53 pm
Location: Denver, CO


Return to DGS Search

Who is online

Users browsing this forum: Google [Bot] and 2 guests

cron