Ok that improved my response time.
Now, what if have queries which dont query the id field at all? Will
the response then be sluggish?
On 7/20/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> On Wed, 2005-07-20 at 11:15 -0700, R S wrote:
> > Actually I deduced the file size is not really the pro
if you write a user defined function and call that from a trigger you could.
On 7/20/05, Sudhir Hasbe <[EMAIL PROTECTED]> wrote:
> Hi All,
> This maybe a strange question to ask but Can I write or call
> C/C++ based triggers. I mean either write a trigger in C/C++ or call a C/C++
> lib
Hi All,
This maybe a strange question to ask but Can I write or call
C/C++ based triggers. I mean either write a trigger in C/C++ or call a C/C++
library from the SQL based trigger.
Regards
Sudhir Hasbe
On Jul 20, 2005, at 1:15 PM, R S wrote:
Actually I deduced the file size is not really the problem.
After reaching 6 mill records, I ran a simple query asking for the
last 50 records from my app.
Using strace I figured that the DB is actually running thru *all the
records* to return me the las
On Wed, 2005-07-20 at 11:15 -0700, R S wrote:
> Actually I deduced the file size is not really the problem.
>
> After reaching 6 mill records, I ran a simple query asking for the
> last 50 records from my app.
> Using strace I figured that the DB is actually running thru *all the
> records* to ret
Actually I deduced the file size is not really the problem.
After reaching 6 mill records, I ran a simple query asking for the
last 50 records from my app.
Using strace I figured that the DB is actually running thru *all the
records* to return me the last 50 and while doing that it locked the
DB!
Actually it is an ext3...and I guess the File Size limitation on ext3 is 4TB.
On 7/20/05, F.W.A. van Leeuwen <[EMAIL PROTECTED]> wrote:
> t the same as PARTIT
Dr Hipp,
I am just playing devils advocate here because I have completed much
Java programming in a multi-threaded application. :)
I understand the problems of multi-threading. I am reminded that it
took nearly 20 years of development to get multi-processor support in a
modern OS stable. Much
Thank you very much for the writing!
Unfortunately, i've found that i not only need to fix the SQLite 2.8 dump
callback routine (i did it already for my database), but rather make the
SQLite 3 backward compatible. The reason is that i have a lot of scripts
from SQLite 2.8, for example database
Thank you for your response.
>Unfortunately for you, I believe that most peoples response would be,
>either use 3.x...
This is not an option. Importing with 3.x does not solve this problem.
Although I think 3.x it could be modified to retain the leading zeros
depending on the field type (e.g.,
3. Now i dump my SQLite 2.8. database using .dump command and got
following
script:
BEGIN TRANSACTION;
create table codes(code TEXT);
INSERT INTO codes VALUES(00);
INSERT INTO codes VALUES(011);
COMMIT;
4. It works great when recreating the SQLite 2.8 database, but when
run on
This looks
> In my application, I call upon the method sqlite3_exec(). This
> method returns the results of request SQL in a function:
> callback(int argc, char **argv, char **azColName).
> This function "callback" displays then the results:
>
> int i;
> for(i=0; i {
> printf("%s = %s\n", azColName[i
Hello,
In my application, I call upon the method sqlite3_exec(). This
method returns the results of request SQL in a function:
callback(int argc, char **argv, char **azColName).
This function "callback" displays then the results:
int i;
for(i=0; iand that the table USER is created with: CREATE T
>
> >
> > Re: 3) Six million and (not) counting:
> >I don't really know, but are you perhaps on a FAT filesystem with a
> > 2GByte filesize limit?
> No. Its an ext2 :-(
> When the DB got locked the partition usage was just 6%!
>
FILE SIZE limitation is not the same as PARTITION SIZE limita
Dear list,
I am trying to build Sqlite3 on ZETA but am having trouble disabling Large
File Support. Of course, ZETA supports very large files but not in the way
expected.
What is the best way to do this? I thought it might be with some setting
for configure but I haven't got this to work yet.
Sergey,
I asked the mailing list about this issue last week but I did not get a
reply. This problem is documented in ticket 923.
I am still hoping someone could think of a work around or tell me if it
is agreed that this is a bug (or not).
Shawn M. Downey
MPR Associates
632 Plank Road, Suite 11
Hello All,
I'm having a problem with the 'manifest typing' concept used in SQLite3.
The problem is as follows:
1. I have a table in SQLite 2.8 database, containing list of city telephone
codes. It is important that the codes are text values because leading zeros
is significant in this case. So t
17 matches
Mail list logo