-
Re: 10.7 Web Resource
zbynek.botlo Jun 10, 2014 5:37 AM (in response to bwicks)Hi bwicks,
This swql query isn't directly converted to sql query. In this case data are retrieved from the business layer which is using several sql queries to prepare the data for swis. To find out if the problem is on the database side you may try sql queries like this:
select * from Pollers
where (PollerType like '%cpu%' or PollerType like '%memory%') and Enabled = 1
select * from DeviceStudio_PollerAssignments pa
join DeviceStudio_Pollers p on pa.PollerID = p.PollerID
join DeviceStudio_Technologies t on p.TechnologyID = t.TechnologyID
where t.Name = 'CPU Memory' and pa.Enabled = 1
If these queries are fast then the problem is probably in data processing and you can create support ticket and attach diagnostics so we can take a look.
Thanks,
Zbynek Botlo
-
Re: 10.7 Web Resource
bwicks Jun 10, 2014 3:24 PM (in response to zbynek.botlo)The first query takes ~3 seconds.. the 2nd query returns 0 results and 0 seconds. Question does the "6551" get added to those queries like example
select * from Pollers
where (PollerType like '%cpu%' or PollerType like '%memory%') and Enabled = 1 and netobjectid = 6551
The reason i ask is our pollers table is pretty big
select count(*) from pollers
-----------
1662172
(1 row(s) affected)
I am working to put in a ticket now
-
-