best performance for storage of server information for python CGI web app?

Aahz aahz at pythoncraft.com
Sat Nov 28 12:38:13 EST 2009


In article <58e5cd75-75be-4785-8e79-4903643965ce at e31g2000vbm.googlegroups.com>,
davidj411  <davidj411 at gmail.com> wrote:
>
>i was also thinking about using SQL Lite with one DB to store all the
>info. with this option, i would not have to worry about concurrent
>updates, but as the file size increases, i could expect performance to
>suffer again?

Depends what you mean by "suffer".  Performance always decreases as size
gets larger unless you take specific steps (such as better algorithms or
bigger hardware).  Using indexes should give SQLite reasonable
performance; you can always upgrade to a faster SQL implementation or
switch to another kind of storage.  But honestly, until you get to
millions of records, you should be fine with SQLite.
-- 
Aahz (aahz at pythoncraft.com)           <*>         http://www.pythoncraft.com/

The best way to get information on Usenet is not to ask a question, but
to post the wrong information.  



More information about the Python-list mailing list