Re: best performance for storage of server information for python CGI web app?
In article <58e5cd75-75be-4785-8e79-490364396...@e31g2000vbm.googlegroups.com>, davidj411 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 (a...@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. -- http://mail.python.org/mailman/listinfo/python-list
best performance for storage of server information for python CGI web app?
I am wondering what will give me the best performance for storing information about the servers in our environment. currently i store all info about all servers in a single shelve file, but i have concerns. 1) as the size of the shelve file increases, will performance suffer ? 2) what about if 2 updates occur at the same time to the shelve file? when a shelve file is opened, is the whole file read into memory? if either scenario (1 or 2) is true, then should i think about creating a shelve file per server? 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? I am running Python 2.6 CGI scripts on Apache web server on windows platform. they interact with the current shelve file to pull info or request info from a python service which will go collect the info and put it into the shelve file. -- http://mail.python.org/mailman/listinfo/python-list