[sqlite] Multiple databases

2008-01-22 Thread Mina R Waheeb
Hi, I have few questions regarding the limitation of multiple databases with SQLite. I have a large number of SQLite DB files with the same structure i need to query them all (looking for speed), I have tried ATTACH method and its working fine but there is a limitation on the number of attached

Re: [sqlite] remote access to sqlite db?

2007-09-03 Thread Mina R Waheeb
On 9/4/07, Scott Derrick <[EMAIL PROTECTED]> wrote: > You could always use rails and get to your database through an html > connection. You can take your choice of web servers though the built in > mongrel-rails server will easily handle 20-30 concurrent connections. > > Scott > > Kees Nuyt wrote:

Re: [sqlite] Aggregate and query limit

2007-08-18 Thread Mina R Waheeb
Hi, Yes, You are right. How SQLite will know the position of the row 990 unless it ordered by indexed field. That takes me to another point, How SQLite exactly interpret the query, I read in the documentation "After the parser assembles tokens into complete SQL statements, it calls the code gene

Re: [sqlite] Aggregate and query limit

2007-08-17 Thread Mina R Waheeb
on with limit 990,10? Thanks, Mina. On 8/17/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > --- Mina R Waheeb <[EMAIL PROTECTED]> wrote: > > I have some questions about the behavior of aggregate functions and > > the result LIMIT. > > After register TEST function and exe

Re: [sqlite] Aggregate and query limit

2007-08-17 Thread Mina R Waheeb
. On 8/17/07, Sreedhar.a <[EMAIL PROTECTED]> wrote: > Hi, > > One idea,Please check whether each row has 11 elements. > That's could be the reason why u have got 33 times call back. > > > Best Regards, > A.Sreedhar. > > > -Original Message- &g

[sqlite] Aggregate and query limit

2007-08-16 Thread Mina R Waheeb
Hi, I have some questions about the behavior of aggregate functions and the result LIMIT. After register TEST function and executing query (SELECT TEST() FROM objects group by id LIMIT 30,3) I was expect calling back TEST() only 3 times but what happened is the TEST() is called 33 time, and the

[sqlite] sqlite3_value LOST

2007-08-14 Thread Mina R Waheeb
Hi, I'm trying to pass object pointer from aggregate function to the result set. The function set the result in this way: Mem *pBest; pBest = sqliteMalloc(sizeof(*pBest)); if( !pBest ) return; pBest->i = toref(value); // i set //pBest->r = 0; //pBest->z = 0; pBest->flags = MEM_Static; pBest->typ