Recent content by TomBascom

While I am in the process of building a dump & load process I find it helpful to make a backup of the empty database after all of the schema has been loaded and the area assignments are complete. I then save that somewhere. Then, after a dry run which loads all of the data and builds all of the...

Note: if you are doing “tablemove”… that step should be with a database that has the schema but NO data yet. Technically you can move populated tables but it is EXTREMELY slow and EXCRUTIATINGLY painful for non trivial amounts of data. Like in days or weeks…

Also - don't use "mark backed up". You need an actual backup if you are ever going to restore and roll forward.

Isn't there a way to get the last few error messages?

The following is an edge case -- not a general recommendation... Sometimes you might have a very small and very frequently accessed table. (Actually almost everyone has some of those.) In such a case you may have a lot of contention for BHT and BF1, BF2, BF3, and BF4 latches. The BF* latches...

If you after ultimate speed and “logical scatter” isn’t a big factor for you then index 0 can be wicked fast.

“Dump specified” predates threaded dumps. It allows you do do a partial dump (perhaps the current year if you have a date field indexed) or, pre -thread, break the data into groups

Ron, Are you thinking of “dump specified” where you supply the range for each “thread”? That’s a very different beast from using the -threads proutil option.

The threaded dump can be very effective but, as George mentions, it will depend on your indexes. And you might benefit from doing an idxcompact first to clean up your post purge situation.

Seems to be.

Sure. On the other hand you could use some cue other than a scroll bar to tell the user that there is something out there. For instance, it is possible to have a fill-in that is wider than the available space. And in a character screen you probably don't want to be drawing boxes around that and...

There are frame attributes such as "scrollable" and "scrollbar-horizontal" that allow you to control scroll bars. As for frames that are wider than the screen... sometimes that's useful. ProTop has a couple of panels that are much, much wider than even the standard ProTop screen of 160 columns...

"Useful" is in the eye of the beholder... If the sorts of things that you are developing and whatever framework you are using make use of it then it might be useful. But an awful lot of frameworks ignore it.

Another thought has occurred to me... is the problem code perchance running as a scheduled task?

Well, yes. But since that has not happened yet I am suspicious that the malware known as "anti-virus" may be doing something to interfere with the proper operation of the code.