RE: [sqlite] SQLITE readonly Performance on a CD DB

Vis Naicker uttered: [EMAIL PROTECTED] uttered: the blob database... within 1.5sec or less from the CD. ... LED on the CD rom blinking only occasionally, not constantly like when I copy a file. [If the LED only lights when data is being transferred, then what you're seeing is the latenc

RE: [sqlite] SQLITE readonly Performance on a CD DB

[EMAIL PROTECTED] uttered: > I have 300K ..and the blob .. separate database.. CD > media, the performance .. 2 minutes sometime > to retreive the result >>>[Is the cdrom noisy at this point? Making intermittent whirring noises? Some cdroms are noisier than others.] * I tried different discs

Re: [sqlite] SQLITE readonly Performance on a CD DB

[EMAIL PROTECTED] uttered: I have 300K records in my database and the blob text file (invoices) in a separate database. I query the database over a network or USB stick and the performance is good. However when I moved my database to CD media, the performance dropped drastically. It takes 2 mi

Re: [sqlite] SQLITE readonly Performance on a CD DB

[EMAIL PROTECTED] wrote: > I have 300K records in my database and the blob text file (invoices) in = > a separate database. I query the database over a network or USB stick an= > d the performance is good. However when I moved my database to CD media,= > the performance dropped drastically. It tak