hello,
until now I used only small / simple databases in Python with sqlite3.
Now I've a large and rather complex database.
The most simple query (with just a result of 100 rows),
takes about 70 seconds.
And all that time is consumed in cursor.fetchall
Using the same database in Delphi,
using
until now I used only small / simple databases in Python with sqlite3.
Now I've a large and rather complex database.
The most simple query (with just a result of 100 rows),
takes about 70 seconds.
And all that time is consumed in cursor.fetchall
Using the same database in Delphi,
using the same
Tim Chase wrote:
until now I used only small / simple databases in Python with sqlite3.
Now I've a large and rather complex database.
The most simple query (with just a result of 100 rows),
takes about 70 seconds.
And all that time is consumed in cursor.fetchall
Using the same database in
On Thu, Jul 23, 2009 at 9:02 AM, Stef Mientkistef.mien...@gmail.com wrote:
btw, I don't know if it's of any importance, the SQL-statement I perform is
select OPNAMEN.*, NAME, NAME_, SCORES.SCORE, PATIENT.*
from OPNAMEN
inner join POID_VLID on OPNAMEN.POID =
Stef Mientki stef.mien...@gmail.com (SM) wrote:
SM btw, I don't know if it's of any importance, the SQL-statement I perform is
SM select OPNAMEN.*, NAME, NAME_, SCORES.SCORE, PATIENT.*
SM from OPNAMEN
SMinner join POID_VLID on OPNAMEN.POID=
POID_VLID.POID
SMinner
Piet van Oostrum wrote:
Stef Mientki stef.mien...@gmail.com (SM) wrote:
SM btw, I don't know if it's of any importance, the SQL-statement I perform is
SM select OPNAMEN.*, NAME, NAME_, SCORES.SCORE, PATIENT.*
SM from OPNAMEN
SMinner join POID_VLID on OPNAMEN.POID
David Stanek wrote:
On Thu, Jul 23, 2009 at 9:02 AM, Stef Mientkistef.mien...@gmail.com wrote:
btw, I don't know if it's of any importance, the SQL-statement I perform is
select OPNAMEN.*, NAME, NAME_, SCORES.SCORE, PATIENT.*
from OPNAMEN
inner join POID_VLID on OPNAMEN.POID
David Stanek dsta...@dstanek.com wrote:
On Thu, Jul 23, 2009 at 9:02 AM, Stef Mientkistef.mien...@gmail.com wrote:
btw, I don't know if it's of any importance, the SQL-statement I perform is
select OPNAMEN.*, NAME, NAME_, SCORES.SCORE, PATIENT.*
from OPNAMEN
inner join POID_VLID
On Thu, Jul 23, 2009 at 4:29 PM, Nick Craig-Woodn...@craig-wood.com wrote:
In all the databases I've used, the like operator has been case
insensitive, so if that is the problem you could use
This is not true in all databases! Many times, this is something that
is configurable when setting up
On Jul 23, 3:58 pm, Stef Mientki stef.mien...@gmail.com wrote:
Piet van Oostrum wrote:
Stef Mientki stef.mien...@gmail.com (SM) wrote:
SM btw, I don't know if it's of any importance, the SQL-statement I
perform is
SM select OPNAMEN.*, NAME, NAME_, SCORES.SCORE, PATIENT.*
SM from
Che M wrote:
On Jul 23, 3:58 pm, Stef Mientki stef.mien...@gmail.com wrote:
Piet van Oostrum wrote:
Stef Mientki stef.mien...@gmail.com (SM) wrote:
SM btw, I don't know if it's of any importance, the SQL-statement I perform is
SM select OPNAMEN.*, NAME, NAME_,
On Thu, Jul 23, 2009 at 6:29 PM, Stef Mientkistef.mien...@gmail.com wrote:
but because the same SQL-statement in Delphi performed well,
I thought it was a problem with the Python implementation.
Same SQL, but were you also using Sqlite in Delphi?
--
David
blog: http://www.traceback.org
12 matches
Mail list logo