dba_optimize

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Galahad
Forum Contributor
Posts: 111
Joined: Fri Jun 14, 2002 5:50 pm

dba_optimize

Post by Galahad »

I'm doing a really simple meta-tag keyword search for a site. I'm using the dba_* funtions (with gdbm) because I don't need the power of mySQL. I have a crawler that crawls our site (and no others) to populate the database. It is working quite nicely. However, I am wondering if it is worth it to use the dba_optimize function? What exactly does it do? The php manual says that on some setups it will optimize the database, while others do nothing. Is there a way to tell if it actually does something? Thanks for the help.
Galahad
Forum Contributor
Posts: 111
Joined: Fri Jun 14, 2002 5:50 pm

Post by Galahad »

Just so you know: I did a test where I saved a copy of the database before calling a dba_optimize and compared it (using diff) to the database after calling it. It was different, although the database isn't really big enough to see if it made a significant change in the performance. So I guess dba_optimize with gdbm really does something, although I still don't know how beneficial it is.
Post Reply