Re: [sqlite] Fw: Slow sqlite_step

Eric, Thanks for the quick response. > Sounds to me like the matching rows are located near the beginning of > the table's physical storage, so you get them quickly, and then the next > sqlite3_step() has to scan the rest of the table. An idea worth testing, but using the official sqlite3 console

Re: [sqlite] Fw: Slow sqlite_step

Carl Jacobs wrote: Hello, I'm a new user to this group as I haven't had any issues with sqlite till now. I tried searching to see if this question has been asked before, but couldn't find anything. I'm using Windows. I have a table with ~45 colums and ~17000 records. I do a search for some stuf

Re: [sqlite] Is it possible to determine if data is string or numeric inside a callback in C?

Downey, Shawn wrote: Does anyone know if it is possible to determine if data is string or numeric inside a callback in C++? I am using sqlite 3.2.7. Unless you have some requirements that your code be compatible with SQLite 2.*, I'd suggest you rewrite it to use the prepare/step interface; t

[sqlite] Fw: Slow sqlite_step

Hello, I'm a new user to this group as I haven't had any issues with sqlite till now. I tried searching to see if this question has been asked before, but couldn't find anything. I'm using Windows. I have a table with ~45 colums and ~17000 records. I do a search for some stuff using 'SELECT * FR

Re: [sqlite] error compiling with GCC 3.2.3 on Red Hat Linux

--- Mike Miller <[EMAIL PROTECTED]> wrote: > Would any of you know what has gone wrong here? The Tcl package shipped with older redhat linux distros is compiled with options incompatible with SQLite (and lots of other packages too). Easiest way to overcome this is to install ActiveTcl or c

Re: [sqlite] Database design and SQLite

On 1/14/06, michael munson <[EMAIL PROTECTED]> wrote: > Greetings, > I'm a bit new to SQL and SQLite so pardon me if I ask silly questions but I > have run into a bit of a wall while attempting to design a database for a C++ > program I am attempting to write. > > The needs of the database are to

Re: [sqlite] Is it possible to determine if data is string or numeric inside a callback in C?

"Downey, Shawn" <[EMAIL PROTECTED]> wrote: > Does anyone know if it is possible to determine if data is string or > numeric inside a callback in C++? I am using sqlite 3.2.7. > sqlite3_exec() converts everything to a string before the callback is invoked, of course. You could modify the existin

[sqlite] Is it possible to determine if data is string or numeric inside a callback in C?

Does anyone know if it is possible to determine if data is string or numeric inside a callback in C++? I am using sqlite 3.2.7. Background: A table with no data type specified for a field may be populated with an unquoted number. For example: create table t1 (a); insert into t1 value

[sqlite] error compiling with GCC 3.2.3 on Red Hat Linux

Would any of you know what has gone wrong here? src/tclsqlite.c: In function `DbUpdateHandler': src/tclsqlite.c:338: warning: passing arg 3 of `Tcl_ListObjAppendElement' makes pointer from integer without a cast src/tclsqlite.c: In function `tclSqlFunc': src/tclsqlite.c:424: warning: passing

Re: [sqlite] multiple database attach with SQLite

"Rajan, Vivek K" <[EMAIL PROTECTED]> wrote: > > * What is the max number of databases which can be attached to a > single process using SQLite? That is set at compile-time by the MAX_ATTACH macro. The default value is 10. There are places in the code that use an integer as a bit vector to

[sqlite] multiple database attach with SQLite

Hello- I have some questions regarding attaching multiple databases with SQLite: * What is the max number of databases which can be attached to a single process using SQLite? * Has someone tried attached large number of databases with SQLite, and are there any performance tradeof