Talk:Database Abstraction Layer

Syntaxerror90 — Fri, 13 Nov 2009 09:51:20 GMT

← Older revision		Revision as of 09:51, 13 November 2009
Line 10:		Line 10:

	Whilst some of the API arguments make a passing comment to caching, you really need to address this in this page or as a supplementary. The DB abstraction layer uses the cache class and the principle is that any SQL queries which are reasonably non-volatile and where result-set coherence is not essential should specify a time-to-live (''ttl'') parameter. This informs the db abstraction layer that the result of the query can be cached for ''ttl'' seconds. An example of where this is used is the count of guests visiting any given forum. This count is a snapshot that is only updated every 10 minutes... This plus discussion of the cache implementations (file, memcache, apc, xcache) would be very helpful for those trying to improve the efficiency of their installations. — [[User:Terrye\|Terrye]] 10:50, 28 May 2009 (UTC)		Whilst some of the API arguments make a passing comment to caching, you really need to address this in this page or as a supplementary. The DB abstraction layer uses the cache class and the principle is that any SQL queries which are reasonably non-volatile and where result-set coherence is not essential should specify a time-to-live (''ttl'') parameter. This informs the db abstraction layer that the result of the query can be cached for ''ttl'' seconds. An example of where this is used is the count of guests visiting any given forum. This count is a snapshot that is only updated every 10 minutes... This plus discussion of the cache implementations (file, memcache, apc, xcache) would be very helpful for those trying to improve the efficiency of their installations. — [[User:Terrye\|Terrye]] 10:50, 28 May 2009 (UTC)
		+
		+	== sql_in_set and DELETE ==
		+
		+	A very important function of the sql_in_set method was overlooked; It is used a lot for deleting data, we need an example and a some explanation. In addition that method isn't very well explained in general, it barley scratches the surface as to what this can do to your queries and how you structure them with this tool in dbal.

	== Will this work?? ==		== Will this work?? ==

phpBB Development Wiki - Recent changes [en]

Talk:Database Abstraction Layer