makiju
16th November 2001, 20:19
Can someone explain why this tiitm001 is very slow to export by using bdbpre6.1?
I think it can't be size of a row or extents...
At this time this happens with Oracle 8.1.6 / IVc4 (3-tier).
db_resource is not tuned at the moment for export. Other tables are always much quicker...lets say 2-3 thousand rows/second and tiitm001 speed is around 100 rows/ 5 secs.
:confused:

frigyesg
26th November 2001, 12:29
Without to know, how your system is configured:
The table tiitm001 is one of tha largest in baan IVc4 (148 fields, 12 indexes). The duration of an export is of course longer, then at small tables with few fields, because 1 row needs more space in the db.