[Stackless] Connecting To A Database
radix at twistedmatrix.com
Mon Jun 11 19:08:42 CEST 2007
On 6/11/07, seun.osewa at gmail.com <seun.osewa at gmail.com> wrote:
> Hello Guys,
> I appreciate your excellent suggestions very much.
> I decided to go with the built-in Sqlite database when I discovered
> that a simple query on an indexed column takes about 1ms on my low-end
> 1.1Ghz Old Celeron Machine (2 times as fast as an identical MySQL
> query, and even faster than Memcached).
> I feel that what I lose in concurrency can be gained back by the
> increased speed, and as long as I have enough RAM, my server never has
> to block. SQLite also uses much less memory and disk space, which
> means more data can fit in memory.
Sounds great. I often go with this -- there's very little concurrency
to gain especially when you don't have to hit the network. Sqlite is
> I just need to break down long-running queries and operations into
> little bits and call stackless.schedule() in between each bit. For
> really slow operations like full text search, I will just use
> something like lucene running in a different process on the same
I've also done similar things.
International Man of Twistery
Stackless mailing list
Stackless at stackless.com
More information about the Stackless