John Toliver wrote:
CHECKPOINT DEFRAG
Click on the execute button
I will look into doing this. Will this by any chance improve the
performance of the database? I've found that searching takes much more
time as I both add data to the database and modify reports etc.
I don't have any numbers to give you on that. Generally speaking I would
say yes, but only if the amount of 'dead' space is a significant
percentage of the overall size of the tables.
For performance purposes you would get more return for you investment in
looking at how you are forming queries and the proper use of indexes.
How is that beneficial in backing up the database
incrementally?
Well, here I was keying in on something in the way you phrased the
question. I see now it was a mistake, or I was mistaken in my reading of it.
Normally, I do no see the need to do separate backups of just the
database component in a Base file that includes an HSQLdb database.
There are folks however, that do. My feeling is that it is a left over
from past experiences using other tools.
Of course that does not mean, do not do backups, you should most
definitely do that. Just go ahead and backup the entire file. Here is
one small catch. OpenOffice.org tends to hold onto the connection to a
Base file after it has been closed until OpenOffice.org is completely
out of memory. If you open a Base file ( talking about embedded
databases only ) use it, open a Writer file, and then close the Base
file while Writer is open ( or the Quickstarter under Windows ) the
connection is not closed. If you copied the physical Base file to a
backup media at this moment you are not really getting what you want.
You would have to insure that all of OpenOffice.org is closed before you
do your copy. One advantage to using the SCRIPT command that I will give
to those that do it is that this is a none issue. When that command is
issued the script file is up to date, up to the second of the last
update to the data - no ambiguity is possible.
--
OpenOffice.org User Community Forum: http://user.services.openoffice.org
United States PostgreSQL Association: http://www.postgresql.us/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
