[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Compacting database



PureBytes Links

Trading Reference Links

Thanks to all who offered advice following my inquiry under the above subject.
Since I have TS 3.5 my filenames lack the '40' prefix, but are otherwise the same.
It seems that the copy out, delete and paste back in procedure is the only way to do it.  However there is 
another wrinkle to this that is worth mentioning here.

For my first attempt, I selected ALL the symbols remaining in my portfolio, and copied them out to a single 
fileset (3.5 makes 4 files, a .DAT file and 3 others, for each copy operation).  I then closed the server, 
deleted the .DAT and .IDX files, opened the server again, and attempted to paste in the data.  The result was 
to simply hang the server, which I had to kill with a 3-finger reset.  I tried several more times, with the same 
result.  The copied data was about 25 megs, and took over 2 hours to make - 2 wasted hours as it turns out.

I then restored the original .DAT file from my tape copy, and tried selecting a smaller group of sysmbols.  By 
experimentation, I found that any copied out file of over about 3 megs is unreadable by the server.  So I had 
to do the job by creating many small copy sets under different names, and then paste them in one by one, 
which meant another 3 hours sitting at the computer.  Not a fun way to spend my Sunday!

Surely there ought to be some way to compress the database without all this tedious work.

JAMES SEMMONS wrote:
> 
> Copy out all and delete the 40bonn.dat file. Don't delete the 40bonn.idx
> file. This is your portfolio and all names. Scary I know. But then paste
> all back in this will consolidate all previously deleted contracts. If
> this sound scary make a back up of your .dat file with and x copy first.
> Call omega for confirmation and details.
> 
> James Semmons http://members.sockets.net/~jsemmons