[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 takes 2 minutes sometime to ret= > reive the result. The CPU is not busy during the time, and the memory us= > age increases slowly. > > When the user selects a row, the system queries the blob database, and h= > ere I am able to retreive the text, convert it into a tiff file, and loa= > d it into my program within 1.5sec or less from the CD. Copying the data= > base to the hard drive and querying that resumes with normal performance= > . Querying the CD version (immeadiately) and the performance lags agai= > n. The LED on the CD rom blinking only occasionally, not constantly like= > when I copy a file. > > Both databases have 300k records, the first(invoice no indexed) has 8 re= > trieval fields, while the second has just the ID and blob. The average r= > ow size is 60-80 bytes, while the blob has on average 500bytes. I am loo= > king to improve the performance, and reasons for the failings. It does s= > ound like cacheing mentioned in the thread ... >
What happens if you run VACUUM on the database before you put it on the CD? -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
