[Zope] Slow ODBC source

[Oleg Broytmann]

On Wed, 26 Jul 2000, Jelle Gerbrandy wrote:
> I'm retrieving data from an Access database, on windows 98, via an ODBC
> connection, and my problem is that it is very very slow: retrieving 1 record
> is fast enough, but retrieving 20 records takes 20 seconds, occupies my CPU
> completely and has my harddisk running hard.
> 
> I've done a little bit of testing, and the time it takes to retrieve the
> data seems not be related to the complexity of the query or the number of
> records, but to the amount of information retrieved (i.e. retrieving long
> strings takes much longer than small numbers).
> 
> Any suggestions?

   Using Win98 for database and WWW? No.

Upgrade!

   win98 => Linux of FreeBSD
   Access => PostgreSQL or MySQL or Interbase
   ODBC DA => corresponding DA

   FreeBSD is pretty stable, but is a bit harder to install and maintain for
novice. Linux is simpler, if you use user-oriented distribution (SuSe,
Caldera, Corel).

   MySQL is superfast, but supports only a limited subset of SQL.
PostgreSQL supports a good deal of complex SQL, but is a bit slow.
Interbase is relatively fast mid-range SQL server.

   All these DBs have Zope Database Adapters.

Oleg.            (All opinions are mine and not of my employer)
---- 
    Oleg Broytmann      Foundation for Effective Policies      phd@phd.russ.ru
           Programmers don't die, they just GOSUB without RETURN.