It also depends on the synchronous pragma. If you leave synchronous on with a disk DB, you will see a huge improvement with an "in-memory". With synchronous off, there is not that big an improvement until you start inserting large amounts of data. You will then start seeing a slight improvement. Totally unscientific observation.
Rick Keiner On 6/26/06, Joe Wilson <[EMAIL PROTECTED]> wrote:
--- "Meier, Roger" <[EMAIL PROTECTED]> wrote: > Hi, > > What factor of speed improvement could I expect with a memory database? > > The database is located on compact flash(vfat) and has a size of 1 MB. > > Thank you very much > > Roger Meier It depends what you mean by 'memory database' and the hardware you're using. Compact flash as read by a USB port is a couple orders of magnitudes slower than system memory on a PC. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
