In a message dated 9/23/2004 7:55:20 AM Eastern Daylight Time, [EMAIL PROTECTED] writes:
Can anyone tell me (or point me to any documentation) about the differences in speed between using an on-disk DB and an in-memory one? The speed difference would depends on how you use the database. If you use the default mode, which is synchronous=full, and do a lot of insert/update/delete without transaction, you can gain speed 100 folder by using a in-memory database. However, if you do a lot of insert/update/delete, but wrap them in a transaction, then the performance gain is much much less. Wei
