On Fri, Feb 23, 2007 at 10:20:21PM +0200, Peter Damoc wrote:
> Everything work decently well if I don't use the orderBy clause...
> If I do use it the entire GUI slows to a crawl
IWBN if you do an experiment to find out who is responsible for the
slowness. First, run the program in a command-line script and add the "for"
loop around it:
for patient in Patient.select(orderBy=Patient.q.name):
print patient
Then, if the script works fast enough, draw all patients as a list:
patients = list(Patient.select(orderBy=Patient.q.name))
and use the list in your wxPython program. If the program is still slow
then the slowness is in wxPython.
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
