Hi Drew,
Am Montag, den 05.11.2007, 09:37 -0500 schrieb Drew Jensen:
> Well, just thought I would drop a note since I said I was going to work
> on these this last weekend.
>
> Didn't really get a chance to do all that I had hoped.
>
> I did find this.
>
> The 128K incremental increase in memory I was experiencing was the
> Virtual Memory manager at play.
>
> Turns out that when my machine required a restore of the OS a few months
> back it brought in a very old setting, where the swap file was not a
> static size but rather was set to start at 2 Megs and grow up to a
> little over a Gig. ( The default setting for XP by the way ) This is not
> good with Base at all, but then it isn't really good overall either.
> Forcing a static swap file at the max size made a huge difference.
Did you see an soffice process hanging sometimes when working with
multiple databases and copying tables?
I had some time to re-test with Windows 2000 and here are the updated
results:
<snip>
table view
----------
big table HSQL MSAfile(ODBC) W2k
0 -> 65534 12s 4s 58s
65534 -> 0 <1s <1s 1s
0 -> 65534 <1s 1s 1s
showing one screen skimming pages at the end ~1s (51 rows visible)
opening table ~8s <1s 5s
closing table ~5s <1s 3s
small table (7 rows)
opening <1s <1s <1s
closing ~5s <1s 2s
form view
---------
table control showing the same table
0 -> 65534 11s 5s 58s
65534 -> 0 <1s 1s 1s
0 -> 65534 <1s 2s 1s
opening form ~6s <1s 7s
closing form <1s <1s <1s
query
-----
selecting all having value>200 (14,074 rows)
~8s ? ~3s
SELECT "ID", "Geraet", "Wert" FROM "Messdaten" WHERE ( ( "Wert" > 200 ) )
closing query 4s <1s 2s
copy from db to db
------------------
copying big table from one internal hsql odb to another
using clipboard 90s (w98se) 6m5s (w2k)
copying big table from internal HSQL to local Access file (ODBC)
using clipboard 7m55s (w98se) 9m26s (w2k)
copying big table from local Access file (ODBC) to internal HSQL
creating primary key (no way declaring in wizard)
using clipboard 90s (w98se - shortly after that the machine was 30s
unresponsible
writing to disk, hsql's writing timer hit) 9m44s (w2k)
anything done with OO.o 2.3.0 / Java 1.5.0_06
</snip>
Regards
Marc
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
