I'm sorry to burst your bubble, Charles, but the size of your GeoFile
database is not what's causing your problem.
CL>> The files which crashed are larger ones - more than 150 (maybe 200)
CL>> records. I have never had a smaller one crash. It happens when I
CL>> try to open a file. Then, instead of opening properly, I get the
CL>> typical error message about pressing E to try to exit cleanly. I
CL>> think that it is a KR09 error.
My GeoFile database for the subscriber and sample mailing lists for my
monthly canine newspaper presently has 1896 data records in it. Each
record has 13 fields, one of which contains all of the information about
the subscriber's dog sports activities and identification of breeds
owned and whether the person is a breeder or not and sometimes has as
many as three or four full lines of narrative text in it.
I don't even export data from GeoFile to make a set of mailing labels.
Instead I am working with marked records inside my GeoFile. I use a
GeoFile generated label layout format to print 3-across mailing labels
direct from the database after marking and selecting the list for a
particular month, so the entire database is open all the time I am
working with it. Each month's label list uses about 1/3 of the full
database but varies from month to month as to names because I send
the sample copies on a rotating percentage basis.
The only time I get a KR-09 nowadays is if I ask for too many pages
of 3-across 30 to a page labels to print in one queue. When I generate
a typical mailing list, it takes 24 to 26 pages of labels. The more
you ask for, the slower GEOS can do it because it is holding so much
information in memory. So, if I ask for more than 20 pages to print,
I get an immediate lock-up or KR-09 after the first few minutes of
sending to the printer. If I ask for 12 to 20 pages, it would be
forever getting the first page through the printer. Even 6 takes a
good while. I have found my best results come from asking for the
first 3 pages, then the next 3, and so on until I am finished. Then
I get an average of 1 page every 1-1/2 to 2 minutes on my laser printer
using "text only fastest way" as my selection. (The normal output
of my printer is 4 pages a minute of plain narrative text).
CL>> The problem is not system dependent. It has happened on various
CL>> systems
I think it is a problem with your handles setting in Preferences or
that you are not shutting off your screen saver before attempting to
sort or print from GeoFile.
The other possibility might be that you are not saving as you exit
in order to exit cleanly. Even if you did a save, you should "close"
so that GEOS asks if you want to "save" and you can say "yes" for a
clean exit. Someone more technical than I can explain it better, I
am sure, but I have found that doing a save every few records is not
the same as the exit save. Yes, the save every few records is saving
the new ones to the datafile, but the save on exit is what lets GEOS
put everything back where it should be or whatever it does to have
the file right when you open it the next time.
CL>> The only consistent factor present appears to be the number
CL>> of records in the file, as mentioned above.
Negatory. What you are describing as a large number of records (200)
is only a small percentage of what I am working with all the time and
have been since spring 1994. This factor is NOT the cause of the
problem.
First go into Preferences and see what your handles are. If not already
there, put them to 3500.
Second, if you trying to sort or print, go into Preferences and disable
your screen saver while you are doing those tasks. When GEOS is in
the middle of shuffling stuff around and your mouse is still for too
long and the screen saver comes on it interferes with the sort. I
have gotten KR-09's several times because I started a big sort with
my screen saver on and walked away from the computer to do something
else while it was working.
FWIW, also, I never installed the 2.01 patch so everything I am doing
is with the 2.0 version which has been very stable for me from the
day it was installed.
Anne Page
* SLMR 2.1a * I'm a Proud User of GeoWorks Ensemble 2.0!
--- QScan/PCB v1.16b / 01-0075
---------------
* Origin: PSL Online Houston, TX 713-442-6704 @psl-online.com (1:106/6256)
|