Pieter van Dieren
1-Dec-2005, 12:54 AM
It's me again. :-)
I'm a bit confused here.
The Connectivity Kit documentation recommends me (on page 20) to turn off
the Pervasive Client Cache. So I did.
But the whitepaper "How to syccessfully Install Pervasive.SQL for DataFlex"
that comes with the CK as well, tells me to experiment with the client cache
and do some tests to see what gives the best performance.
Erm... So, should it be on or off?
Another problem I have:
I've converted a program to Pervasive.
So I did a simple comparison: I took a database containing about 35000
records, and made a query that writes the data to an ascii file.
With the embedded dataflex database, it takes about 1 minute.
With the pervasive database, this takes about 2.5 minutes!
I've done the test several times with the same results.
Another test with a report is a lot slower in Pervasive as well.
Server: Pervasive.SQL 9.1 SP1 in Windows 2003 server
Client: Windows XP
What have I done wrong?
--
Pieter
I'm a bit confused here.
The Connectivity Kit documentation recommends me (on page 20) to turn off
the Pervasive Client Cache. So I did.
But the whitepaper "How to syccessfully Install Pervasive.SQL for DataFlex"
that comes with the CK as well, tells me to experiment with the client cache
and do some tests to see what gives the best performance.
Erm... So, should it be on or off?
Another problem I have:
I've converted a program to Pervasive.
So I did a simple comparison: I took a database containing about 35000
records, and made a query that writes the data to an ascii file.
With the embedded dataflex database, it takes about 1 minute.
With the pervasive database, this takes about 2.5 minutes!
I've done the test several times with the same results.
Another test with a report is a lot slower in Pervasive as well.
Server: Pervasive.SQL 9.1 SP1 in Windows 2003 server
Client: Windows XP
What have I done wrong?
--
Pieter