I was afraid of that. I will try creating temp table and see how it works. Thanks
Dan Goldberg -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of James Bentley Sent: Monday, November 24, 2008 3:42 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SYS_COLUMNS TABLE SLOW 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
