[Tutor] Shelve del not reducing file size

[Eric Brunson]

Andreas Kostyrka wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
>
> Eric Brunson wrote:
>   
>> On Sat, July 28, 2007 4:01 am, Thorsten Kampe wrote:
>>     
>>> * Kent Johnson (Fri, 27 Jul 2007 08:06:33 -0400)
>>>
>>>       
>>>> Barton David wrote:
>>>>
>>>>         
>>>>> *sigh* I'm really going off Python.
>>>>>
>>>>>           
>>>> In what way is it Python's fault that the dbm database doesn't reclaim
>>>> disk space?
>>>>         
>>> It's actually how most databases work. Even a simple Outlook pst file
>>> (which is a database, too) works this way. I thought everyone knows or
>>> heard about this.
>>>       
>> I don't even think mysql reclaims disk space unless you intervene.
>>     
>
> As this thread got already very philosophical, I'd like to add that the
> jury is still out if mysql is a RDBMS. I personally interpret it as a
> datafile access library that tries to pretend to be a database system :)
>   

I had 13 years of Oracle experience under my belt when I tried MySQL 
version 3.x.  Then it was a toy database and barely worth my attention.  
We're now using 5.0 and it is definitely no longer simply pretending to 
be a database. 

At work we have a system that is storing over 1.5 billion records and 
makes our Oracle installations pale in comparison.  Another system is 
running distributed in a cluster running multiple masters in ring 
replication.  Oracle was either impressed or threatened enough to buy 
the rights to InnoDB, that has to say something about the state of 
MySQL.  With the addition of stored procedures, triggers and views in 
5.0, it has definitely met all but my most esoteric needs.

I'm not saying MySQL is perfect, I have several bugs and feature 
requests logged with MySQL that I'm still waiting to be addressed, but 
if you haven't used it lately, you're missing out.


> Andreas
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.2 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFGq7m7HJdudm4KnO0RAr6CAKCTSLxA5blSX19IVfpN1RVywRZvSACghExR
> iRDi3pk+NBPhIcQdd1QkP70=
> =eS7Q
> -----END PGP SIGNATURE-----
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> http://mail.python.org/mailman/listinfo/tutor
>