Compact on close... IF?

[GoinDeep]

I would like my db to compact on close if the file size exceeds xxMB's.

I was trying to use an IF..Then..Else statement in VB, But I cant seem to find the command or code which will identify the current file size.

Any ideas?

 

[Rich]

Why not just compact it every time you close it?

 

[GoinDeep]

The compact seems to be rather time consuming on this particular database. The database start out at 15MB and over time can grow to over 100MB. I would like the Compact to kick in when it exceeds 70MB.

 

[Rich]

I'd say the compact is tacking a long time due to the fact you're letting it grow, having said that why is it growing so much?

 

[GoinDeep]

Thats a good question. I posted the growing problem a few weeks ago and could never fiqure it out. The database copies data from a main server and loads working tables I have set up on the computer.


The database is working very well inspight of the growing problems, performance is better than expected. I worked on several different database stratagies to decrease the growing effect and found the performance suffered.