Marc Santhoff wrote:
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
Thanks Marc,
All running on Win98se w/ 1 Gig RAM ( I don't suppose that is an Intel
PIII 266Mhz is it ?)
Till later
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]