I am trying to get the following wuery to run under Sybase 11.0 for WindowsNT: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!
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
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 297 |
Nodes: | 16 (2 / 14) |
Uptime: | 15:32:37 |
Calls: | 6,667 |
Calls today: | 1 |
Files: | 12,216 |
Messages: | 5,336,692 |