*This message was transferred with a trial version of CommuniGate(tm) Pro* Paolo,
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.
Rolf Brusletto PHP / MySQL Coder http://www.phpexamples.net
Paolo Bonavoglia wrote:
*This message was transferred with a trial version of CommuniGate(tm) Pro*
My school has a site on a HP NetServer E200 with Win2000 Server and Apache-Php. There are many web-pages accessing Paradox databases with the odbc PhP functions.
Now the system is very slow in answering to DB queries; e.g. I have a graphic counter which uses a Paradox tables to record info about visitors; when the table bocomes too big (about 10-20000 rows) the counter becomes very very slow; only cutting the table to the last hundreds of visits, the counter behaves good.
Why is the system so slow for big tables? it is a Paradox matter, a ODBC matter, a Win2000 matter? A hardware (CPU, RAM) matter?
Now I'm looking for the best solution; I have only some ideas:
1. Migrate the server to Linux (I'm trying Mandrake 9.1); but are there Linux ODBC driver for Paradox? Is it true that Apache/Php behaves better on Linux?
2. Migrate from Paradox to MySQL which is said to be very fast and can be managed directly by PhP; but are there tools to easily convert Paradox tables into MySQL? And is MySQL so much faster than Paradox/ODBC to justify the [big] job?
3. Improve the hardware: more RAM, a new server (e.g. a Xeon dual processor). Is it worth the money?
and as you see, I've many doubts too.
Is there somobody which can solve these doubts?
Paolo Bonavoglia --------------------------------------------------------------------------- Webmaster http://www.liceofoscarini.it/ E-Mail paolo.bonavoglia@liceofoscarini.it
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
