[sqlite] some optimisation help?

2004-03-18 Thread Jake Skinner
The following query is very slow. I don't know how to improve my query, and I'm sure I'm doing this just about the slowest way possible!! :( begin sql query == select t1.time, t1.units_processed,

Re: [sqlite] moving from mySQL to SQLite - A guidance request

2004-03-18 Thread Darren Duncan
At 3:12 PM -0500 3/18/04, rich coco wrote: I have a legacy app that uses mySQL as the embedded RDBMS. The app makes explicit invocations to mysql library functions. There is no ODBC layer being used at all. What about existing SQL statements (explicit arguments to mysql function calls) that use

[sqlite] moving from mySQL to SQLite - A guidance request

2004-03-18 Thread rich coco
I have a legacy app that uses mySQL as the embedded RDBMS. The app makes explicit invocations to mysql library functions. There is no ODBC layer being used at all. I wish to replace mySQL with SQLite. Since I am bothering to do this, I wish to introduce an ODBC layer. I have learned about the

Re: [sqlite] phpSQLiteAdmin

2004-03-18 Thread Richard Heyes
> Anybody use phpSQLiteAdmin? (http://www.phpguru.org/phpSQLiteAdmin.html) > Because it don't works for me, no error, only it redirects to a login.php?SessionID=..., and nothing. Do you have session support enabled? Are there any errors displayed ? And have the second release (dated March, not

[sqlite] Resetting cursor position

2004-03-18 Thread Michele Santucci
Hi ML, after I execute an a sqlite_exec() to insert and/or an sqlite_get_table() to retrieve data into a table I think the cursor is then fixed to the end of the recordset so how can I reset its position to the top of the table without having to close/reopen the db? Michele Santucci

Re: [sqlite] phpSQLiteAdmin

2004-03-18 Thread HENNINOT FRÉDÉRIC
Use SQLiteManager http://sourceforge.net/projects/sqlitemanager Le jeu 18/03/2004 à 12:59, Lay András a écrit : Hello! Anybody use phpSQLiteAdmin? (http://www.phpguru.org/phpSQLiteAdmin.html) Because it don't works for me, no error, only it redirects to a login.php?SessionID=..., and

Re: [sqlite] more performance questions

2004-03-18 Thread D. Richard Hipp
[EMAIL PROTECTED] wrote: > I'm trying to insert some 1,000 rows a second, with about 200-300 bytes per > row--it's overview data from an NNTP server. Also, FWIW, this is on OS X and > I've bumped the page size up to 4096 since that's the memory page size (I > think), and the rows were exactly the