On Wednesday, 19 November 1997 at 08:00:00 UTC,
gle...@mindspring.com wrote:
I am trying to get the following wuery to run under Sybase 11.0 for WindowsNT:
select product_tag, market_tag, period_tag, "modalp", catgry_cd,
ad_price,
from tmp_modal
group by product_tag, market_tag, period_tag
having pricecount=Max(pricecount) and ad_price=Max(ad_price)
the problem is that it is running extremely slow ( about 1.5 rows per
second) even though it is the only job running on a dual Pentium Pro
machine with an Ultra-wide SCSI RAID controller. Whats really strange
is that there is virtually no hard drive activity and the SQL server
is only using 50% of CPU time ( the other half is the system idle
process).
Anyone have any ideas?
Glen Koundry
gle...@mindspring.com
I just googled 'why is synapse so slow?' (we're running a migration project to the cloud), and the top answer is this 26 year old thread! Somehow I doubt the thread has anything relevant to add LOL! ...kinda cool to see though!
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)