Hi
> How is possible to use some facility like caching data to eliminate
> trafic from and to firebird server?
Could you please post an example of sql server caching ??
Cache is verry useful for webapp.
There are many type of cache (from page cache to sql cache)
For page cache responsible is web server (APACHE or IIS) and could be
achived with line like:
<%@ OutputCache Duration="10" VaryByName="*" %>
Before take advanteges from sqlcaching for SQL Server database must run:
aspnet_regsql -S computer_name -U sa -d database_name -ed -et -t
table_name
This create triggers an proc in database for table_name.
In web.config must enable caching:
<system.web>
<caching>
<sqlCacheDependency enabled="true" poolTime="3000">
<database>
<add connectionStringName = "MyConn"
name="name_of_conn"/>
</databases>
</sqlCacheDependency>
</caching>
....
Aspx file will contain
<%@ OutputCache Duration="10" VaryByName="*" SqlDependency="name_of_conn:
table_name" %>
This will fire database on each 3 seconds to see all updates,
Or with
<%@ OutputCache Duration="10" VaryByName="*" SqlDependency
="CommandNotification %>
and in global.asax puting
System.Data.SqlClient.SqlDependency.Start(ConfigurationManager.ConnectionStr
ings("MyConn").ConnectionString);
Entire system will fire database only when update will apear.
Some video sample could be seen on
http://blogs.msdn.com/acoat/rss_tag_Web+Development+Editorial.xml
Thanks,
Pau
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
