dba_optimize
Moderator: General Moderators
dba_optimize
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.
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.