Dear Dennis,
At 21:12 2/05/01 -0500, you wrote:
>don't try to populate a table with part of the sys_columns table. Project a
>temporary table that contains the data from the WHOLE sys_columns table.
>Then base your views on that table instead.
>There will be some overhead creating the temp table but from then on, all is
>super fast.
Rather than use a temp table that took that long on startup I came to the same
conclusion as Ben posted, that of creating a permanent table and
dropping/rebuilding
it after each update involving a schema change.
Thanks again for the tipoff re the inadvisability of directly using system
tables.
Warmest regards,
Tom Grimshaw
coy: Just For You Software
tel: 61 (0)2 9552 3311
fax: 61 (0)2 9566 2164
email: [EMAIL PROTECTED]
mobile: 0414 675 903
street: 3/66 Wentworth Park Rd Glebe NSW 2037
post: PO Box 470 Glebe NSW 2037 Australia
_/_/_/_/_/_/_/_/ _/_/_/_/_/_/ _/ _/ _/_/_/_/_/
_/ _/ _/ _/ _/
_/ _/ _/ _/ _/
_/ _/_/_/_/ _/ _/_/_/_/_/
_/ _/ _/ _/
_/ _/ _/ _/ _/
_/ _/ _/ _/_/_/_/_/
