Subject: An Unreasonable Figure
From: Gurrola
To: Rixster
> An OS X guru suggested this week that 10,000 items in a list
> view was an unreasonable figure, that application domains never
> approach anything of that size. John's directories had twice that
> 10,000 and more - and we still had to compensate for his stone age
> network connection.
>
> There is no such thing as 'an unreasonable figure'.
Remember that special version of X-scan you made me that would save
the result of its findings?
Recap: We used a FileNet (previously called WaterMark) document
imaging application which runs on top of a MS-SQL 6.5 Db. Images
scanned are stored on Magneto Optical disk in TIFF format with
special file information loaded into the header and that same info
is contained within a matching named WMK file. WMKs are smaller,
thus faster to search through, so I use X-scan to find all WMK files
on the MO and save those search results and pop them into X-base.
One MO disk contains 15,258 WMK files; another I just looked at had
32,587.
What I did with these was made a VB/JavaScript to parse the WMK
files out, separating a nil char with a comma. Now I imported each
of these files into an Access database and then ODBC'd them into a
new SQL2000 Db for safe keeping.
I could not have done this without X-scan saving the results, as
MS's search tool crapped out at 10,000.
You saved my bacon. That SQL database died a very painful and
un-restorable death. $6700 worth of expert SQL'ers could not fix it,
but your tools had already saved the important info.