Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to implement caching
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
01234794
Message ID:
01235518
Views:
15
Andrus,

>I plan database access in report expressions like
>
>=psql("select name from customer where id="+myid.value)
>
>MS ReportViewer control invokes those expressions multiple times.
>So it takes 5 minutes to show the report if server is in internet.
>
>So I need to cache all data access, using field caching.
>I havent found any sample to implement field caching.
>So I think I should use record (object) level caching where every table record is read fully from internet.

Rather than hard-coding these sorts of expressions you should use business objects instead. In your business object methods you can determine if the requested data is already present--if it's not, you can retrieve it.

Best Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform