|
micnie_2020
Posting Yak Master
Malaysia
188 Posts |
 Posted - 11/30/2012 : 05:35:18
|
Hi All,
I have 2 SP:-
1. Use a lot of
set @sSQL=@sSQL+' from tbl'+@username+' '
OPEN contact_cursor;
FETCH NEXT FROM contact_cursor
Time Taking for same sql statement when print @sSQL: 2:50:45
2. ... from tbl
OPEN contact_cursor;
FETCH NEXT FROM contact_cursor
Time Taking for same sql statement when print @sSQL: 00:50:45
May i know how can i perform all the table with dynamic name with faster speed? Coz all the table involved calculation & insert into the table created based on username.
Thank you.
Regards,
Micheale |
|
Table with dynamic name caused loading slow
