Re: best solution to for loop

2005-09-22 Thread Dan
> Hi, I have several apps which connect to a database, fetch some data > an put this into a gtk.TreeStore, but if the result set is 1500 row > long, the app response slowly The first thing to test is whether it's Python or the database that's the bottleneck. 1500 rows isn't all that much for a da

best solution to for loop

2005-09-21 Thread Mauricio Tellez
Hi, I have several apps which connect to a database,  fetch some data an put this into a gtk.TreeStore, but if the result set is 1500 row long, the app response slowly, how can optimize this? here is an example of what I do: cur.execute("SELECT * FROM clients")data = ""> for row in data:    treeS