slowness connecting to the iapplicationstat table

[mickss]

Hi everybody,

I have experimented this strange thing: when executing a query on the iApplicationStat table the results appear after two or three minutes while on the other tables it takes a few seconds. Has anybody experimented it? I work with SCCS v. 4.01.07


Thank you

 

[Supernn]

The iApplicationStat table is one of the largest tables within Symposium. You should always keep in mind that this table stores alot of data for every 15 minutes, so this increases rapidly.

Use a timestamp within your queries to reach the fastest respons time and try to limit the amount of data retrieving from this table.
If you would look into the data stored in this table, you will see many columns.

 

[mickss]

You are right but I also have problems with this simple query:
&quot;SELECT Timestamp, CallsAbandonedAftThreshold, Application FROM blue.dbo.iApplicationStat iApplicationStat WHERE (Application='App') AND {fn DAYOFMONTH(Timestamp)} = 10 AND {fn MONTH(Timestamp)}= 11 AND {fn HOUR(Timestamp)}>=8 AND {fn HOUR(Timestamp)}<=21 ORDER BY Timestamp&quot;

It takes two minutes to show me the results when I launch it by Microsoft Query from Excel.
But the problem remains still when retrieving data by Cristal Report while building up the SELECT part of the query through the wizard.

I set up the statistics' duration interval to 110 days. Is it too long?

 

[Supernn]

I personally think it's too long, but it depends on who runs queries and reports in your company.

Did you try to use Access for reporting? I find it much quicker then Excel. If you setup the connection and create a new table use the &quot;Link Table&quot; option, otherwise you would import all data. you can even store a reporting password in this link.