RE: Need for Speed...
More information would be nice.
O/S version
Hardware
onstat -c
onstat -m
onstat -p
onstat -g iof
onstat -D
vmstat 5 10
iostat 5 10
Size of tables involved in the query.
The query itself.
I am sure I want more info, but I cant think of anything else
off the top of my head.
Will
>===== Original Message From "jmorales@nettaxi.com" <jmorales@nettaxi.com>
=====
>Hi Gurus,
>
> I have a query, Tables fragmented into 5 DBSpaces, and the other tables
reside into 2 DBSpaces (7 DBSpaces in all), Problem: query is to slow. How can
i speed up my query. BTW, were using Metacube Server 4.x.
>
> TABLE1, TABLE2, TABLE3 fragmented in 5 DBSpace ( 5 diff. disk)
>
> TABLE4, TABLE5 ... (DBSpace6)
> TABLEn... (DBSpace7)
>
> Client ---> Metacube Server/Web Server ---> Informix 7.X
> (Browser) (Database)
>
>Regards,
>
>Jose'
>
>
>
>
>
>
>------------------------------------------------------------
>Why pay for Internet Service when you can get it for FREE?
>http://www.nettaxi.com
------------------------------------------------------------
This e-mail has been sent to you courtesy of OperaMail, as a free service from
Opera Software, makers of the award-winning Web Browser, Opera. Visit us at
http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail
account is waiting at: http://www.operamail.com/
------------------------------------------------------------