Re: [SQL] Pick random rows from SELECT?

2009-09-23 Thread Gilles Ganault
On Mon, 21 Sep 2009 21:40:02 -0700, Dennis Lee Bieber wlfr...@ix.netcom.com wrote: I'd suggest either a pool of threads -- 5-10, each reading company names from a shared QUEUE, which is populated by the main thread (remember to commit() so that you don't block on database updates by the

[SQL] Pick random rows from SELECT?

2009-09-22 Thread Threader Slash
... Threader -- Forwarded message -- From: Dennis Lee Bieber wlfr...@ix.netcom.com To: python-list@python.org Date: Mon, 21 Sep 2009 21:40:02 -0700 Subject: Re: [SQL] Pick random rows from SELECT? On Mon, 21 Sep 2009 10:59:38 +0200, Gilles Ganault nos...@nospam.com declaimed the following

[SQL] Pick random rows from SELECT?

2009-09-21 Thread Gilles Ganault
Hello I have a working Python script that SELECTs rows from a database to fetch a company's name from a web-based database. Since this list is quite big and the site is the bottleneck, I'd like to run multiple instances of this script, and figured a solution would be to pick rows at

Re: [SQL] Pick random rows from SELECT?

2009-09-21 Thread Peter Otten
Gilles Ganault wrote: I have a working Python script that SELECTs rows from a database to fetch a company's name from a web-based database. Since this list is quite big and the site is the bottleneck, I'd like to run multiple instances of this script, and figured a solution would be to