Dan, To the best of my knowledge there is no way to speed up the SYS_COLUMNS "table". As you note it is really a system view for information contained in the ".RB1/RX1" file. The data is in a very different form than that presented by the SYSTEM VIEW of that table.
If you don't need all of the rows or columns of SYS_COLUMNS you might consider creating a temporary table and INSERT specific information you need. Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 ----- Original Message ---- From: Dan Goldberg <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, November 24, 2008 5:24:53 PM Subject: [RBASE-L] - SYS_COLUMNS TABLE SLOW When I scroll down through the sys_columns it is very slow. It is also slow to bring up columns in the ad-hoc form. Is there a way to speed it up or get the sys_column names and table ids?? I noticed it says it is a System view. TIA Dan Goldberg
