Re: sqlite3 alternative option

2008-06-27 Thread Petite Abeille
On Jun 26, 2008, at 10:55 PM, Gandalf wrote: I have almost million records so I need a better solution. SQLite shouldn't have any issue handling such a load. Perhaps this is an operator, hmmm, issue? -- PA. http://alt.textdrive.com/nanoki/ -- http://mail.python.org/mailman/listinfo/pytho

Re: sqlite3 alternative option

2008-06-27 Thread Carsten Haese
Uwe Grauer wrote: I suggested Firebird because the OP asked: > Hi every one I'm looking for a good alternative db to replace sqlite That he did, but people ask for what they think they need, which isn't always what they really need. In this particular case, sqlite was not the problem. The OP

Re: sqlite3 alternative option

2008-06-27 Thread Uwe Grauer
Gerhard Häring wrote: Uwe Grauer wrote: Use Firebird. It has a small footprint and runs in different enviroments from embedded to server with single process per connection. Firebird may be nice, but has nothing to do with this performance problem. I suggested Firebird because the OP asked: >

Re: sqlite3 alternative option

2008-06-27 Thread Gerhard Häring
Uwe Grauer wrote: Gandalf wrote: Hi every one I'm looking for a good alternative db to replace sqlite I'm using pySQlite3, And I tried to translate very big database from Mysql to sqlite. I generated through PHP a python script that insert 200,000 records to my sqlite db and took me more then

Re: sqlite3 alternative option

2008-06-27 Thread Uwe Grauer
Gandalf wrote: Hi every one I'm looking for a good alternative db to replace sqlite I'm using pySQlite3, And I tried to translate very big database from Mysql to sqlite. I generated through PHP a python script that insert 200,000 records to my sqlite db and took me more then 5 hours and managed

Re: sqlite3 alternative option

2008-06-26 Thread Gandalf
you where right! thank you ! -- http://mail.python.org/mailman/listinfo/python-list

Re: sqlite3 alternative option

2008-06-26 Thread jay graves
On Jun 26, 6:30 pm, Allen <[EMAIL PROTECTED]> wrote: > Gandalf wrote: > > Hi every one I'm looking for a good alternative db to replace sqlite > > > I'm using pySQlite3, And I tried to translate very big database from > > Mysql to sqlite. > > I generated through  PHP a python script that insert 200

Re: sqlite3 alternative option

2008-06-26 Thread Allen
Gandalf wrote: Hi every one I'm looking for a good alternative db to replace sqlite I'm using pySQlite3, And I tried to translate very big database from Mysql to sqlite. I generated through PHP a python script that insert 200,000 records to my sqlite db and took me more then 5 hours and managed

sqlite3 alternative option

2008-06-26 Thread Gandalf
Hi every one I'm looking for a good alternative db to replace sqlite I'm using pySQlite3, And I tried to translate very big database from Mysql to sqlite. I generated through PHP a python script that insert 200,000 records to my sqlite db and took me more then 5 hours and managed to insert only