[sqlite] What is the proper use of threads?

If you really need to invoke SQLite from a single handler, consider opening a separate database connection for use by the signal handler. I actually do. I'll try with a separate handler and get back to you -- hopefully in a couple of days. Eventually rather than experimenting with it, I

[sqlite] query limited

Hello, somebody know a way for create a query limited, for example, select 100 lines of a table that have 100, without to use where clause, like do Ms SQLServer with select top. Thanks. CiberCorreos® Acercando las Nuevas Tecnologías a la

RE: [sqlite] query limited

Yes, this is exactly that i need. thanks. CiberCorreos® Acercando las Nuevas Tecnologías a la población. http://www.ciudadano.cu/ - To unsubscribe, send email to [EMAIL

[sqlite] [ANN]SQLight v2 - complete Manager/Browser/Editor for SQLite Databases

http://www.sqlight.com/ Complete Rewrite. The only database manager for SQLite that allows query results to be edited in a meaningful order! Try editing the data returned from a simple query like this in any other SQLite manager. "SELECT rowid,Product,Name,Description,Price,SKU FROM

Re: [sqlite] SQLite and McAfee Anti-Virus

> After sending my email I realized the blame is partly with > me because SQLite is putting is own name on TEMP files. > I changed this so that the prefix is now "etilqs_" instead > of "sqlite_". That should help head off future troubles. I think this is worse. Veritas does something similar

[sqlite] Can primary key columns be altered to use autoincrement?

I have a small database in which tables have columns that were created as integer primary key, but not autoincrement. I would like to make sure keys are never reused, so I want to add autoincrement to the column definition. Is that possible? As near as I could tell from the docs, it's not

Re: [sqlite] Can primary key columns be altered to use autoincrement?

On Thu, 2 Nov 2006, Rob Richardson wrote: I have a small database in which tables have columns that were created as integer primary key, but not autoincrement. I would like to make sure keys are never reused, so I want to add autoincrement to the column definition. Is that possible? Rob,

[sqlite] massive insert

I have a table where i insert data massively near 10,000 or 20,000 rows and that take to much time, near 1h for each 10,000 rows. How i can increase the performance for this operation?. In other case... How i can insert multiples rows in one INSERT statment?? Thanks.

Re: [sqlite] massive insert

My friend.. very simple... use a transaction to do that... BEGIN; insert into ... insert into ... insert into ... insert into ... ... ... ... insert into ... COMMIT; I usually insert 1 in 5 seconds in a non good PC -- Cesar Rodas http://www.phpclasses.org/grank

[sqlite] Another question on single-thread intent

I know the restriction of passing open databases across threads. What I'm wondering is whether that's really a process/thread issue, or a concern over making sure two or more threads don't muck with a single database at the same time. Basically, I'm exploring how I might implement database

[sqlite] Re: massive insert

[EMAIL PROTECTED] wrote: I have a table where i insert data massively near 10,000 or 20,000 rows and that take to much time, near 1h for each 10,000 rows. How i can increase the performance for this operation?. Make sure to perform all these insertions in a single transaction: issue a BEGIN

Re: [sqlite] massive insert

surround them in a transaction. BEGIN INSERT... INSERT... COMMIT On 11/2/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I have a table where i insert data massively near 10,000 or 20,000 rows and that take to much time, near 1h for each 10,000 rows. How i can increase the performance for

[sqlite] Re: Another question on single-thread intent

David Gewirtz wrote: I know the restriction of passing open databases across threads. What I'm wondering is whether that's really a process/thread issue, or a concern over making sure two or more threads don't muck with a single database at the same time. The requirement is really a

RE: [sqlite] Sqlite DB file sizes

How difficult would it be to change my version of Sqlite such that it uses 32-bit floats instead of doubles for REAL values in memory? Could you point me in the right direction? We are in a real shortage for RAM in our game. Thank you very much, Dave Gierok -Original Message- From:

Re: [sqlite] Sqlite DB file sizes

Dave Gierok <[EMAIL PROTECTED]> wrote: > How difficult would it be to change my version of Sqlite such that it uses = > 32-bit floats instead of doubles for REAL values in memory? Could you poin= > t me in the right direction? We are in a real shortage for RAM in our game= > .. The routines

Re: [sqlite] Another question on single-thread intent

David Gewirtz wrote: I know the restriction of passing open databases across threads. What I'm wondering is whether that's really a process/thread issue, or a concern over making sure two or more threads don't muck with a single database at the same time. Basically, I'm exploring how I might

[sqlite] PHP 5.2.0 pdo_sqlite SQLITE Version

I just did a compile of PHP 5.2.0 with (in part) this configure string: --with-pdo-sqlite=/usr/local/sqlite-3.3.8/lib \ on a Fedora Core 5 machine. Running phpinfo() lists the SQLite library version as 3.3.3 for PDO SQLite. That puzzles me. The path information I passed to PHP's configure is