[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
http://radix.twistedmatrix.com/
http://twistedmatrix.com/
http://canonical.com/

_______________________________________________
Stackless mailing list
Stackless at stackless.com
http://www.stackless.com/mailman/listinfo/stackless



More information about the Stackless mailing list