Re: sqlite3 performance problems only in python

[Stef Mientki]

David Stanek wrote:

On Thu, Jul 23, 2009 at 9:02 AM, Stef Mientki<stef.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            = POID_VLID.POID
  inner join VRAAGLST           on VRAAGLST.VLID           = POID_VLID.VLID
  inner join VLID_SSID          on VRAAGLST.VLID           = VLID_SSID.VLID
  inner join SUBSCHAAL_GEGEVENS on SUBSCHAAL_GEGEVENS.SSID = VLID_SSID.SSID
  inner join POID_SSID_SCID     on ( OPNAMEN.POID            =
POID_SSID_SCID.POID ) and
                                   ( SUBSCHAAL_GEGEVENS.SSID =
POID_SSID_SCID.SSID )
  inner join SCORES             on SCORES.SCID             =
POID_SSID_SCID.SCID
  inner join PID_POID           on OPNAMEN.POID            = PID_POID.POID
  inner join PATIENT            on PATIENT.PID             = PID_POID.PID
 where substr ( lower( NAME) , 1, 6)  = 'cis20r'
  and lower ( NAME_ ) = 'fatigue'
  and TEST_COUNT in (3,4)
  and DATETIME > 39814.0
  and SCORE < 30

Warning: I suck at SQL and hate it with a passion...

+1,
but I couldn't find anything better.
I guess you have some better suggestions ?
(I looked at Dee, but from my first view, it looks a bit premature)

thanks,
Stef

--
http://mail.python.org/mailman/listinfo/python-list