Re: [sqlite] Row count in database

Richard, and how about doing both? Using BEGIN ... COMMIT and at the same time turning off syncing? Jakub D. Richard Hipp wrote: Christopher Petrilli wrote: Has anyone had any experience in storing a million or more rows in a SQLite3 database? I've got a database that I've been building, which g

[sqlite] How to connect SQLite with Oracle Forms

Hi, Can someone guide me in connecting SQLite with Oracle Forms. I am designing a Helpdesk system for internal usage. It is for this i need assistance. With advanced thanks and Regards Anantha Narayanan.T.L ICICI Infotech Ltd. [EMAIL PROTECTED] [EMAIL PROTECTED] http://www.geocities.com/tla

Re: [sqlite] Flash memory?

Lee Wenchian Civ AFRL/IFTC wrote: Does anyone know if Sqlite can be loaded and operate solely on flash memory? I plan to use sqlite with a microprocessor that doesn't have any hard drive but only flash memory. I am aware of at least two companies building consumer products that incorporate SQLite a

[sqlite] Flash memory?

Does anyone know if Sqlite can be loaded and operate solely on flash memory? I plan to use sqlite with a microprocessor that doesn't have any hard drive but only flash memory.

Re: [sqlite] Slow ORDER BY on INTEGER PRIMARY KEY

Setzer Sebastian (ext) wrote: Hi, it seems that Queries with ORDER BY (and a LIMIT-Clause to keep the result small) are quite slow if the ORDER BY is on an INTEGER PRIMARY KEY - column. If the ORDER BY is on a normal column for which I made an index, its quite fast. It doesn't help do create an ind

[sqlite] Slow ORDER BY on INTEGER PRIMARY KEY

Hi, it seems that Queries with ORDER BY (and a LIMIT-Clause to keep the result small) are quite slow if the ORDER BY is on an INTEGER PRIMARY KEY - column. If the ORDER BY is on a normal column for which I made an index, its quite fast. It doesn't help do create an index on the primary key (doesn'

Re: [sqlite] OS X/PHP5/SQLite Build> fatal error: no input grammar

spartian wrote: > In this process I'm building mod_php from the /usr/local/src/php-5.0.2 >directory. My configuration line is as follows: > > sudo ./configure --with-apache=../apache_1.3.33 \ > --with-mysql=/usr/local/mysql --enable-track-vars Here is my config for PHP 5.0.2 under OSX: ./c

Re: [sqlite] ODBC ADO

Op vrijdag 17 december 2004 16:33, schreef Jonatan Moleiro: > Try one of these: > > Aducom http://www.aducom.com/sqlite/ (Suppor 2.x and 3.x) This database-component is not recognized as a database-component in the Bold MDA-layer (model driven architecture), so I cannot us it. But I used this co

Re: [sqlite] ODBC ADO

Op donderdag 16 december 2004 16:17, schreef Clay Dowling: > Bert Verhees said: > > Does someone have experience with the ODBC-driver for SQLite3 in > > combination with the ADO layer in Delphi. > > I cannot get it to run, it stumbled about the isolation-level for > > transactions > > I don't have

Re: [sqlite] ODBC ADO

Try one of these: Aducom http://www.aducom.com/sqlite/ (Suppor 2.x and 3.x) Zeos http://www.zeoslib.net/ (Suppor 2.x) Other: http://www.torry.net/pages.php?id=561 (Some components for access SQLite components) Jonatan - Original Message - From: "Bert Verhees" <[EMAIL PROTECTED]> To: "S

Re: [sqlite] ODBC ADO

Bert Verhees said: > Does someone have experience with the ODBC-driver for SQLite3 in > combination with the ADO layer in Delphi. > I cannot get it to run, it stumbled about the isolation-level for > transactions I don't have experience with the specific situation you're describing, but if all yo

[sqlite] ODBC ADO

Does someone have experience with the ODBC-driver for SQLite3 in combination with the ADO layer in Delphi. I cannot get it to run, it stumbled about the isolation-level for transactions Thanks in advance for an answer Bert Verhees