Re: [sqlite] Convert SQLite to Java

k > on that too :-). This company has a C to Java Bytecode compiler. E.g., compile C programs to run on a Java JVM. http://www.axiomsol.com/ I have no idea how this actually works in practice, but any SQLite fan with $49 to burn and some time might want to give it a try.

Re: [sqlite] Large databases howto

file size. I would also recommend running any queries and updates before hand with my IdxChk utility: http://www.sqlite.org/cvstrac/wiki?p=IdxChk IdxChk should help spot any poorly performing queries ahead of time, and verify that your indexes are being used. -- Tom Poindexter [EMAIL PROTECTED] http://www.nyx.net/~tpoindex/

Re: [sqlite] idxchck

type in your select (or other) statement into stdin, the second example is include the select on the command line. -- Tom Poindexter [EMAIL PROTECTED] http://www.nyx.net/~tpoindex/

Re: [sqlite] Performances problem with multi-table query ?

torial of rewriting SELECT statements to achieve better performance. The 'idxchk' program is available from: http://sqlite.org/contrib -- Tom Poindexter [EMAIL PROTECTED] http://www.nyx.net/~tpoindex/

[sqlite] idxchk - a small utility to report index usage on queries.

to reply right away. Enjoy! -- Tom Poindexter [EMAIL PROTECTED] http://www.nyx.net/~tpoindex/

Re: [sqlite] Setting the max length of a text widget

ny help will be highly appreciated. See the Widget Callback Package (Wcb) at http://www.nemethi.de/ -- Tom Poindexter [EMAIL PROTECTED] http://www.nyx.net/~tpoindex/

Re: [sqlite] SQLite & Big Database

decision support database. I see sqlite.db sizes of 2-10gb on a regular basis. -- Tom Poindexter [EMAIL PROTECTED] http://www.nyx.net/~tpoindex/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Fatal error loading large table

> From: Tom Poindexter [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 11, 2003 4:01 PM > To: [EMAIL PROTECTED] > Subject: [sqlite] Fatal error loading large table I finally built SQLite with large file support on AIX 5.2. Thanks to all who replied. I've updated t

Re: [sqlite] Fatal error loading large table

On Fri, Dec 12, 2003 at 12:01:04AM +, Tom Poindexter wrote: > I'm trying to load a fairly large table (~ 7.5 million rows, 1.5 gb of raw > data) with the 'copy' command, and I'm getting a sqlite fatal error: I think large file support didn't get compiled i

[sqlite] Fatal error loading large table

e yet. I'm setting up to run the same input file on Linux right now Any help is greatly appreciated! -- Tom Poindexter [EMAIL PROTECTED] http://www.nyx.net/~tpoindex/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Concurrency in SQLite

ON READ ONLYPostgreSQL SET TRANSACTION READ UNCOMMITTED Sybase I find my current use of temp tables to be a workable solution, although table level locking would simplify my usage somewhat. Best, Tom -- Tom Poindexter [EMAIL PROTECTED] http://www.nyx.net/~tpoi