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.
Ruslan?
Cheers,
Frank+++
--
Günter Schmidt & Co. oHG
Frank Bitterlich eMail: bitterlich .AT. gsco DO.T de
Schlosserstr. 2-4 WWW: http://www.gsco.de/gsco
D-60322 Frankfurt Tel.: 069 / 156809-29
GERMANY Fax: 069 / 156809-28
©2001 Frank Bitterlich |
