Re: [sqlite] can you speed this query up?

2006-05-23 Thread Adrian Ho
On Tue, May 23, 2006 at 08:50:56AM +0200, A. Pagaltzis wrote: * [EMAIL PROTECTED] [EMAIL PROTECTED] [2006-05-23 02:35]: What you have to do is: SELECT qi, ri, drl, score FROM ... WHERE score=(SELECT max(score) FROM ...) Actually, in cases such as this, the easiest

Re: [sqlite] Low Level API for SQLite3

2006-05-08 Thread Adrian Ho
On Mon, May 08, 2006 at 04:06:33PM +1000, Bill KING wrote: Anish Enos Mathew wrote: Well, currently I am doing a mobile project and we are testing the performance of four databases depending on the time it takes to insert or delete or search a particular data from the database. I am using

Re: [sqlite] Strange execution times

2006-02-22 Thread Adrian Ho
On Wed, Feb 22, 2006 at 11:11:45AM +0200, Ulrich Sch?bel wrote: I tried your script and got, after a slight modification, quite consistent results. When I tried it as is, I got slightly varying time results with a peak in the 50 to 100 region. Then I commented out all lines concerning the

Re: [sqlite] Strange execution times

2006-02-21 Thread Adrian Ho
{create table cust_persons ( first_name string, last_name string )} db eval {insert into cust_persons values ('Adrian','Ho')} db eval {insert into cust_persons values ('Thunder','Lightning')} foreach rounds {1 5 10 50 100 500 1000 5000 1} { puts t($rounds)=[time {db eval {select * from