The problem is schema design.
Just use a single task table with another key column for the task number.
Queries on N task tables with UNIONS are killing your performance.
--- Bharath Booshan L <[EMAIL PROTECTED]> wrote:
> TaskN_table
> | Name | TaskID |
>
> TaskN_info_table
>
> | TaskID REFERENCES TaskN_info_table | ProcessID REFERENCES Process_table |
> IsParentProcess |
____________________________________________________________________________________
Got a little couch potato?
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
