Page 1 of 1

database problem?

PostPosted: Fri Feb 24, 2012 11:05 pm
by gellnsh
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

Re: database problem?

PostPosted: Fri Oct 24, 2014 10:35 pm
by sella
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.