from:"Radu Lodina"

Re: [sqlite] Database creation and inserts speedup

2009-05-09 Thread Radu Lodina

Hi, General consideration: A. Run insert in "bulk fashion": BEGIN INSERT INTO /* ~1 - 2000 (or more) inserts line*/ COMMIT B. If index have complex clause please don't create index until you finish data upload in tables. Good look - Original Message - From: "J. R.

Re: [sqlite] Sqlite versus mySQL in PHP

2009-03-27 Thread Radu Lodina

One (and first) shoot: - try to use : BEGIN TRANSACTION COMMIT TRANSACTION - Original Message - From: "Anton Rifco" To: Sent: Friday, March 27, 2009 11:28 AM Subject: [sqlite] Sqlite versus mySQL in PHP > Hi guys, > > I would

Re: [sqlite] Problems with some SQL

2009-03-20 Thread Radu Lodina

The problem: Field UserGroup.UserGroupID is NOT declared as autoincrement field and statement: INSERT INTO UserGroup (UserGroupShortTitle ... don't fill this field. Check yourself with: SELECT * FROM UserGroup Check create autoincrement field : http://www.sqlite.org/faq.html#q1 CREATE TABLE

Re: [sqlite] about DELETE and JOIN

2006-02-09 Thread Radu Lodina

Hi cyrille, Please try: DELETE FROM Words WHERE IID NOT IN ( SELECT Words_ID FROM Feedbacks_has_Words ) Regards Radu Lodina On 2/9/06, Cyrille37 <[EMAIL PROTECTED]> wrote: > > Hello, > > I've got a SELECT query that I would like to transform as a DELETE query , >

Re: [sqlite] SQLite acces from vbScript

2006-01-29 Thread Radu Lodina

Take a look to : http://www.terrainformatica.com/sqlitedb/ Personally I don't use it, but looks nice. Regards Radu Lodina On 1/30/06, John Latimer <[EMAIL PROTECTED]> wrote: > > Thanks for the lead, I'll go looking for it... > > John L> > > Cariotoglou Mik

Re: [sqlite] Lite Network wrapper

2005-11-10 Thread Radu Lodina

Hi - looks great. Do you have a plan to share also the source code of server ? Regards Radu Lodina On 11/11/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > This is a wrapper for SQLite that allows multiple connections accross a > network to a single threaded SQLIte serv

Re: [sqlite] CHECK constraints

2005-11-03 Thread Radu Lodina

Hi, In DB2 7.x the insert statement is also ok. On 11/3/05, Nemanja Corlija <[EMAIL PROTECTED]> wrote: > > > Does the check constraint fail or not? Or do different > > database engines do different things? > In Firebird 1.5 it does fail. > > Though I agree with Darren's remarks, so not failing

Re: [sqlite] Number of rows in a query result

2005-10-27 Thread Radu Lodina

Hi Alfredo, I supose you don't use sqlite3_get_table<http://www.sqlite.org/capi3ref.html#sqlite3_get_table>function right ? Call another query with: SELECT COUNT(*) AS NrRecords FROM ( ) Radu Lodina On 10/28/05, Alfredo Cole <[EMAIL PROTECTED]> wrote: > > Hi: >