on 10/31/01 14:28, Frank Bitterlich at bitterlich /AT/ gsco .DOT de wrote:
> Hi List,
>
> I have noticed something which isn't a real problem for me, but maybe
> someone can explain this... I have a baseobject (600.000 records,
> approx. 70 fields, not linked) that gets approx. 50 record updates and
> 50 new records a day. But once a month, I delete all records and
> re-import them from an external data source.
>
> I have noticed that when I do this the "normal" way (dlete all records,
> flush, start importing) the importing becomes very slow after approx.
> 200.000 records (20 rps and less instead of 350 rps initially). But when
> I do this, but abort the import shortly after beginning, and start it
> over (again delete all records, flush, start importing), the
> records-per-second rate doesn't drop that substantially; at 500.000
> records, I still get about 200-250 rps.
>
> What could be the reason for that? Re-using of database pages where the
> index is stored? As I said, not a real problem sinc I know the
> workaround, but I'm curious about the reason. Using V4RB 1.8.9r4 in a
> PPC app on 9.0.4, app has 100 MB RAM, 50% Valentina cache.
indexes....it looks like in first case indexes exists and Valentina add
record and index it immediately.
after you deleteAll records you use the same cursor ?
you import via cursor ?
--
Best regards,
Ruslan Zasukhin
-------------------------
Paradigma.
e-mail: ruslan@paradigmasoft.com
web : http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on /AT/ lists .DOT macserve.net
©2001 Ruslan Zasukhin |
