I have become very focused on our use (probably overuse) of Notes. Our database is used every day and is very text heavy. In single-user mode it just works and keeps going. In multi-user mode, the exact same database will eventually close all users at the same time for no obvious reason or time. We have tried all kinds of adjustments, reloads, updates, and followed suggestions from this group. We have X Enterprise and have always used the 64 versions through the various versions. I often use 2-3 notes in tables. Some have up to 10. I probably have several hundred Notes in the tables of our system. Why? Because it always worked as I developed our system in single user mode. Never dawned on me that could be a problem in multi-user mode because it works most of the time. Now, after finding rbase-l emails from Albert Berry back in 2003 and Jan Johansen about putting Notes into their own tables, I think I finally understand how I can greatly exceed 4,092 bytes in a row with several large Notes. I read the discussions of broken pointers which is still vague to me. I understand the differences of Text vs. Notes vs. VarChar. Using 'SELECT MAX(SLEN(column)) FROM table' and related statements, I can see there are many Notes I can convert to Text because users simply do not write much while other items (report Summaries can easily exceed 8,000 characters) should be in their own table. Can exceeding the Notes capacity in a row cause system closure problems?
Tom Frederick -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
