DB2 Express-C Global Temporary Table Performance on vista

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DB2 - 08 Apr 2008 01:46 GMT

After I have istalled express version of DB 9.5 on Vista.
I create a stored procedure(used global temporary table),
When i try to execute this procedure, it's very very slow,
even if there is only one row can be fetched.
But I try this on XP instead, it's ok.
Does it Needs addtional setting for global temporary table on Vista?

Thanks in advance.

Reply to this Message

Larry - 08 Apr 2008 04:42 GMT

How much RAM is on the machine? Do you think it's possible that it's
Vista that is usurping the memory?

Larry E.

> After I have istalled express version of DB 9.5 on Vista.
> I create a stored procedure(used global temporary table),
[quoted text clipped - 4 lines]
>
> Thanks in advance.

Reply to this Message