Kashif,
You mean import or linked the tables to Cache ? Nuno
kashif wrote:
SunflowerHi im evaluating Cache 5.0.2.607.1. and copied a single table from my SQL Server to Cache. The table has around 25 columns with just 36000 rows.
I executed
select itemclass, count(*) as Count from items group by itemclass
It takes around 1.3 seconds on Cache, while on MSDE the result shows up immediately. and if i add say "having count(*) < 100" it takes 3 seconds.
Now this is some thing i was not expecting from Cache. (after reading Marketing stuff ) After this i didnt even tried to import the bigger tables to Cache.
I hope some of you might provide some helpfull tuning advices or share simmilar problems.
Thanks in advance
