Re: [sqlite] Calculating Difference between Time using SQLite

On 5/16/08, P Kishor <[EMAIL PROTECTED]> wrote: > On 5/16/08, Scott Baker <[EMAIL PROTECTED]> wrote: > > Miguel wrote: > > > Estimates, > > > First of all, excuse my English, I recognise that it is not my strong. > > > I need to do a query on a table and I return the difference in minutes >

Re: [sqlite] design question / discussion

Thanks for your reply. I have done some quick timing tests on my system; a vacuum can take 5 or more minutes (synchronous full), and a delete and recreate is rougly 3 seconds. I think I did such a test with a 30MB database. The database resides on a jffs2 file system (compression off), which

Re: [sqlite] design question / discussion

> Hi I have a general design question. I have the following senario... IMHO your design sound reasonable. In relation with the vacuum question I suggest try to delete and re-create each table and watch both timings. HTH Adolfo ___ sqlite-users