Re: PSQL 9.7 Single seat slows down

#1

Hi,

I try to set File growth factor to 1%, but this does not resolve the
problm

Regards
Mircea
nmm schrieb:

Quote:

Hi btrivians,

I import about 1 000 000 records from an ascii-file into 6
btrieve-tables. A littel programm decides from the data in which of
that tables the data go.
Now I made a strane observation: the first 500 000 records are
importet very fast: in about 15 mins. The 6 tables than are about 100
MB large. During the second 500 000 the engine decelerates more an
more: it makes periodical brakes of 1/2 secunds or so (you can see
that very nice in the included taskmanager-screenshot).
So reading (and writing) the second 500 000 records lasts about 2 hours.

I guess it becomes harder and harder for the engine to add new pages
the the btrievefiles.

Can I do anything to optmize the engine?

Any hint will be very welcome!

Regards

Mircea

#2

Much of this could be related to your disk performance. Putting the
data on a RAID10 array should improve performance, or try a RAMDISK if
you've got free memory for it.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive Training - July 2009 in Chicago ***

nmm wrote:

Quote:

Hi,

I try to set File growth factor to 1%, but this does not resolve the
problm

Regards
Mircea
nmm schrieb:
Hi btrivians,

I import about 1 000 000 records from an ascii-file into 6
btrieve-tables. A littel programm decides from the data in which of
that tables the data go.
Now I made a strane observation: the first 500 000 records are
importet very fast: in about 15 mins. The 6 tables than are about 100
MB large. During the second 500 000 the engine decelerates more an
more: it makes periodical brakes of 1/2 secunds or so (you can see
that very nice in the included taskmanager-screenshot).
So reading (and writing) the second 500 000 records lasts about 2 hours.

I guess it becomes harder and harder for the engine to add new pages
the the btrievefiles.

Can I do anything to optmize the engine?

Any hint will be very welcome!

Regards

Mircea

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: PSQL 9.7 Single seat slows down

comp.databases.btrieve comp.databases.btrieve

Re: PSQL 9.7 Single seat slows down - 07-12-2009 , 06:35 AM

Re: PSQL 9.7 Single seat slows down - 07-13-2009 , 07:15 PM