Hello,
I'm trying to use SQLObject for a small visits database.
I have these 2 objects:
class Dates(SQLObject):
date = StringCol()
dType = IntCol()
intervClass = IntCol()
intervSubClass = StringCol(default=None)
comments = StringCol()
patient = ForeignKey('Patient')
class Patient(SQLObject):
name = StringCol()
photo = StringCol(default="")
bday = StringCol(default="")
address = StringCol(default="")
phone = StringCol(default="")
comments = StringCol(default="")
dates = MultipleJoin('Dates')
firstDate = StringCol(default="")
Now I try to get a select of the patients ordered alphabetically and push
the data in a wxPython virtual ListCtrl.
self.patients = Patient.select(orderBy=Patient.q.name)
Everything work decently well if I don't use the orderBy clause...
If I do use it the entire GUI slows to a crawl with items in the ListCtrl
drawing one by one... everything moves very very slow.
The back-end is pySQLite and the database has only something like 3000
patients
Am I doing something wrong?
Thank you in advance.
Peter.
--
There is NO FATE, we are the creators.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
