Am Montag, den 29.10.2007, 03:36 -0400 schrieb Andrew Jensen: > I would love to see your numbers then.
Here you are: <snip> table view ---------- big table int.HSQL MSAfile(ODBC) 0 -> 65534 12s 4s 65534 -> 0 <1s <1s 0 -> 65534 <1s 1s showing one screen skimming pages at the end ~1s (51 rows visible) opening table ~8s <1s closing table ~5s <1s small table (7 rows) opening <1s <1s closing ~5s <1s form view --------- table control showing the same table 0 -> 65534 11s 5s 65534 -> 0 <1s 1s 0 -> 65534 <1s 2s opening form ~6s <1s closing form <1s <1s query ----- selecting all having value>200 ~8s (14,074 rows) SELECT "ID", "Geraet", "Wert" FROM "Messdaten" WHERE ( ( "Wert" > 200 ) ) closing query 4s <1s copy from db to db ------------------ copying big table from one internal hsql odb to another using clipboard 90s copying big table from internal HSQL to local Access file (ODBC) using clipboard 7m55s copying big table from local Access file (ODBC) to internal HSQL creating primary key (no way declaring in wizard) using clipboard 90s (could be caching on MSA-side) (shortly after the machine was 30s unresponsible writing to disk, hsql's writing timer hit) anything done with OO.o 2.3.0 </snip> Regards, Marc --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]