[Stackless] Connecting To A Database

Christopher Armstrong 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
quite fast.

> 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
> server.

I've also done similar things.

Christopher Armstrong
International Man of Twistery

Stackless mailing list
Stackless at stackless.com

More information about the Stackless mailing list