Hi Kenny,
[Consider subscribing to the mailing lists you post to. Most replies only go to the list. Please reply to the list only.]
Kenny Lyngberg wrote:
I can tell u what it does, but not how it does it. For example: A db of 500 KB, can be kompressed, with a funtion i Access in MS office. So that this file now only is 350 KB big.
Now, if you run the function again, is it reduced further?
The Jet database engine used by Access handles updates in a way that accumulates garbage over time. Deleted or overwritten data in many cases is not physically removed, but just marked as deleted. The Compress function removes this accumulated fluff and compacts the remaining valid data.
It is quite possible that the database engine used by OpenOffice.org does not have the same flaw, so there is no excess space used which can be freed up.. Similarly consideration apply to a 'Repair' function. Offering this makes sense only if the database engine sufficiently often produces database files, which are broken, but so little that the breakage can be repaired automatically.
You probably won't find the database experts who know our database engine well enough to judge where our engine stands in this regard on this list. Try the users@dba.openoffice.org or dev@dba.openoffice.org lists. ('dba' is the database access project in OpenOffice.org).
I'm sry I can't be at more help. But there's gotta be someone else who ar missing this function?
What function? Even Access cannot make data magically smaller. And no, Access does not (afaik) actually compress the valid data. This function is offered by Access to make up for a defect of the database engine it uses.
So what do you want us to do? Should we introduce the same problem for our database engine so we can offer a similar fixup tools?
This is of course assuming that our database engine is smarter and automatically removes superfluous data eventually. If it isn't, then yes it should probably at least offer a similar tool.
HTH, Joerg
-- Joerg Barfurth Sun Microsystems - Desktop - Hamburg >>>>>>>>>>>>>>>>>> using std::disclaimer <<<<<<<<<<<<<<<<<<<<<<< Software Engineer [EMAIL PROTECTED] OpenOffice.org Configuration http://util.openoffice.org
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
