Re: The DB is very slow.

From: Date: Sat, 10 May 2003 15:12:37 +0000
Subject: Re: The DB is very slow.
References: 1 2  Groups: php.db 
Request: Send a blank email to php-db+get-27643@lists.php.net to get a copy of this message
At 08:44 10/05/2003 10/05/2003, you wrote:
Before you look into any of those, would be possible that the problem would actually be an index problem? If theres no index, or the indexes are built wrong and paradox isn't using them, the larger the db gets, the slower it will run. I've never used paradox before, so I'm not sure if there ARE even indexes. Just an idea.
Paradox does have indexes; e.g. I have two indexes on the visite.db table, one main index and a chrono index. I had already tried to add and change indexes, but it doesn't seem to produce any improvement in speed. Paolo Bonavoglia --------------------------------------------------------------------------- Webmaster http://www.liceofoscarini.it/ E-Mail paolo.bonavoglia@liceofoscarini.it 
        paolo_bonavoglia@virgilio.it


« previous php.db (#27643) next »