Use the cache technology to solve the pressure on accessing the statistical database

Cachevisit CV = new cachevisit ();
Cv. sysno = sysno;
Cv. reurl = reurl;
Cv. IP = getipv4andv6 ();
Cv. moduleclass = moduleclass;

 

If (Cache ["yddvisit"] = NULL)
{
List <cachevisit> CVS = new list <cachevisit> ();
Cvs. Add (CV );
Cache. insert ("yddvisit", CVS );
}
Else
{
List <cachevisit> CVS = (list <cachevisit>) cache ["yddvisit"];
If (CVS. Count <10)
{

Cvs. Add (CV );
Cache. insert ("yddvisit", CVS );
}
Else
{
List <cachevisit> cvs2 = (list <cachevisit>) cache ["yddvisit"];

Foreach (cachevisit CVF in cvs2)
{
If (CVF. reurl = "")
EC. biz. ICBC. icbc_product_dailyclickmanager.getinstance (). Add (CVF. sysno, "", CVF. IP, CVF. moduleclass );
Else
EC. biz. ICBC. icbc_product_dailyclickmanager.getinstance (). Add (CVF. sysno, CVF. reurl, CVF. IP, CVF. moduleclass );
}

Cache. Remove ("yddvisit ");
}
}

 

 

Every time there are 10 records updated to the database, it is better to execute SQL statements at a time!