 enumTableProperties(propTbl)
|
|
|
rum
|
I am trying to research a cause for erratic table corruptions
Step 1 is to compare the properties of all of my tables.
the enumTableProperties("BuildList.DB") returns data in this format..(smaple table is called BuildList.DB)
| BuildList |
BlockSize |
4 |
| BuildList |
BookMarkSize |
17 |
| BuildList |
FieldCount |
14 |
| BuildList |
FilterCount |
0 |
| BuildList |
IndexCount |
0 |
| BuildList |
KeySize |
0 |
| BuildList |
LogicalRecordSize |
72 |
| BuildList |
Name |
BuildList |
| BuildList |
OpenMode |
ReadWrite |
| BuildList |
PhysicalRecordSize |
67 |
| BuildList |
ReferentialCheckCount |
0 |
| BuildList |
ShareMode |
Shared |
| BuildList |
StableBookMarks |
No |
| BuildList |
TableLevel |
7 |
| BuildList |
Type |
PARADOX |
| BuildList |
ValCheckCount |
0 |
My questions are:
1. I see a couple of my tables (TABLELEVEL) are older formats V4 or V5, They have been working this way for years. Anyone know of any problems having soem tables as V7 and others as V4 or 5?
2. What do BookMarkSize and StableBookMarks mean? BookMarkSize varies. 87 of my 250 tables show StableBookMarks = Yes, the rest are No?
3. Blocksizes are erratic. Is it best to have all one size?
Block Size Count of Tables
Next I want to find a method to extract the driver name or CodePage used to create the table
Jeff |
|
Posted 6 years ago (Thread Starter)
|
|
| About rum |
|
Membership pending.
Member subscribes to this thread with a verified email.
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #17855, 1 reply
Thread Started 2/3/2020 1:32:32 PM
View Counter=664
|
|
|
|
Location=Frankfort, KY USA
|
|
| |
Most Recent Post
|
|
| Moderator |
|
Steven.G
|
I think for modern systems, larger block sizes simpify everything.. some of my older tables have become more stable with 16k blocks, but not all.. the one thing about old tables, they only make case sensitive indexes (x0* instead of xg*).. that can make for inconsisent search/range/filter results.. and the possibility that some "corruption" is just different tcursor filter results
and no, I have no idea what the bookmark thing is.. it's been so long, can't even remember thinking about it.. but if you compare the results to table level, it'll probably make sense
I'm leaning more and more to SMB2 as being a factor.. by default, oplocks and caching settings have been reversed.. that can't be good for concurrent writes.. absolutely can't be good
Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN
Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
|
|
Posted 6 years ago
|
|
| About Steven.G |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #17856 (Level 2)
and Parent is 17855
Reply Posted 2/3/2020 2:14:18 PM
|
|
|
|
Location=Myrtle Beach, SC USA
|
|
Revive Thread!
Add a comment to revive this old thread and make this archived thread more useful.
| Thread #17855 Counter |
| 664 |
|
Since 2/3/2020
|
|
|
Paradox
Print This
