SQL standards state that data tables are not sorted. I have not used
sorted tables very much at all, and notice absolutely no problems with
this. R:Base is extremely fast at picking up values from an indexed
column. If you just want to be able to browse your tables in a
particular order, create a view that includes the appropriate order by
clause.
My Cdn $0.01. I'm too old to be worth $0.02.
Fred C Kopp wrote:
Alistair, indeed, you have responded to this issue before and I have
looked up your message of 5/5/05. Why can something so simple in 2.11
be so complicated in 7.6? All I want to do is sort my tables and
leave my keys undisturbed. Am I to understand that everyone else is
content to leave their tables unsorted? If so, I reluctantly bow to
the majority, while I continue to search for a way to defy it.
----- Original Message -----
*From:* Alastair Burr <mailto:[EMAIL PROTECTED]>
*To:* RBASE-L Mailing List <mailto:[email protected]>
*Sent:* Tuesday, June 10, 2008 6:08 PM
*Subject:* [RBASE-L] - Re: Sorted tables
Looking back, Fred, I seem to think that I, for one, have
responded to this question before - on the 7th of Feb to be precise!
I have a command file that re-builds my databases with all the
tables sorted in the sequence I like - it's yours for the cost of
asking for it - it's a bit too big to post here.
As I said previously:
"I also like to re-build my databases at the turn of each year. As
briefly discussed here earlier this year I do this by unloading
the tables in a particular sequence (of tables) so that they can
be reloaded to a new database without conflicts arising due to
missing keys from tables that should have been loaded first.
Since I have to unload the data anyway I do so with the ORDER BY
clause that best suits each table for my needs.
This, effectively, kills two birds with one stone: I get a clean
database and its tables are pre-sorted."
Regards,
Alastair.
----- Original Message -----
*From:* Fred C Kopp <mailto:[EMAIL PROTECTED]>
*To:* RBASE-L Mailing List <mailto:[email protected]>
*Sent:* Tuesday, June 10, 2008 8:51 PM
*Subject:* [RBASE-L] - Sorted tables
What if I'm so *anal retentive* that I want to keep my tables
sorted in certain ways?
In 2.11 I simply ran a file that RENAMEd each table to Temp
and PROJECTed a new, sorted table from Temp. Then I REMOVEd
TABLE Temp and moved on to the next table. After all the
sorted tables were projected, my file would BUILD KEY for each
appropriate column in each appropriate table. A PACK or
RELOAD removed the wasted space.
But things have changed...
PKs and other Restraints prohibit this naive approach. I
don't even want to get into the errors I get. I want a single
control file that sorts my tables and preserves / restores my
Keys and Restraints. Doesn't seem all that unusual. How do I
do it?
Thanks,
Fred
Fred C. Kopp
Authorized R:Base Developer
19 Teri Lane
Washington, PA 15301
P 724-222-7376
F 724-222-7376
C 724-413-5534
E [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.2.0/1493 - Release
Date: 09/06/2008 17:25
