Re: The DB is very slow.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux