I have found integer PKs to work much better than even short text keys, and have stopped using text keys entirely. If I need to use text keys, I still use the integer PK/FK and add a unique index to the text column.
"William Mason" <[EMAIL PROTECTED]> wrote: >Just a follow up to the corrupted text indexes - we have been bitten again by this >bug. �I have never in my years of experience with R:Base had so many index problems, >until (it seems) that we began to use long text values for keys (Text(36)) - perhaps >R:Base is having trouble with these. �FWIW the problem SEEMS to go away when I remove >any FK constraints from the text column(s). �Not a good solution, but a workaround at >least. �The problem only seems to occur on tables that have high concurrent activity >- many users pushing INSERTS at once with FK values (text). �Diagnosed by comparing >the number of records returned by a LIST TABLE with a SELECT COUNT(*) FROM. �I've >been able to sit and watch the two numbers get farther and farther apart. �Users >begin to complain about missing or "ghost" records. �And once it starts, there is no >way to correct it without having all users exit and doing a reload (PACK INDEX does >nothing). �Again, pulling the FK's off of the table seems to hel! p. > >William Mason > __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
