Re: Pickle or Mysql

2006-04-09 Thread amaltasb
Can i install berkeley db on BSD, I am having a virtual private server, so I have privilates to install on it and do we have management tools like phpmyadmin from berkely db as well, as I am not so good at database management. Thanks Amaltas -- http://mail.python.org/mailman/listinfo/python-list

Re: Pickle or Mysql

2006-04-01 Thread Klaas
> Can I use Pickle to store about 500,000 key value pairs.. or should I > use mySql. Which one is best for performance, as the key value pair > increases. Pickle: absolutely out of the question. Mysql: might work, albeit slowly. Use berkeley DB (bsddb3), or zodb. I have no experience with the la

Re: Pickle or Mysql

2006-03-31 Thread Rene Pijlman
[EMAIL PROTECTED]: >Can I use Pickle to store about 500,000 key value pairs.. Performance would be horrible. Use a BTree in ZODB instead: http://www.zope.org/Wikis/ZODB/guide/node6.html#SECTION00063 >or should I use mySql. You should use a relational database, such as PostgreSQL

Re: Pickle or Mysql

2006-03-31 Thread Paul Rubin
[EMAIL PROTECTED] writes: > So, Is Shelve a perfect solution (besides Mysql), to store large > key/value pairs, and which are updated frequently by multiple clients. No, shelve is for use within a single process. With multiple clients and frequent updates, you need a real database and some knowle

Re: Pickle or Mysql

2006-03-31 Thread amaltasb
So, Is Shelve a perfect solution (besides Mysql), to store large key/value pairs, and which are updated frequently by multiple clients. Thanks Paul Rubin wrote: > [EMAIL PROTECTED] writes: > > Can I use Pickle to store about 500,000 key value pairs.. or should I > > use mySql. Which one is best f

Re: Pickle or Mysql

2006-03-31 Thread Paul Rubin
[EMAIL PROTECTED] writes: > Can I use Pickle to store about 500,000 key value pairs.. or should I > use mySql. Which one is best for performance, as the key value pair > increases. That's an awfully large pickle. Maybe you want shelve. If there are frequent updates, multiple clients, etc., then

Pickle or Mysql

2006-03-31 Thread amaltasb
Can I use Pickle to store about 500,000 key value pairs.. or should I use mySql. Which one is best for performance, as the key value pair increases. Thanks -- http://mail.python.org/mailman/listinfo/python-list