Re: cmysql (was: Package proposal)

On Tue, 12 Oct 2004, Maxim Antipin wrote: Good points but... > 2. By default caching mechanism is turned off as default value > 'query_cache_size' is '0' so it depends on hoster wether cache is > actually enabled or not. Even if cache is enabled developer needs to > modify SQL queries: > a) SET SESSION query_cache_type = DEMAND - to allow caching only > explicitly defined by 'SELECT SQL_CACHE' prefix queries. > b) Add 'SQL_CACHE' to all required queries. This will results in > problems with SQL syntax for MySQL 3.xx.xx ... must disagree with this one. query_cache_type defaults to ON. Once query_cache_size is set above zero the caching just magically starts to work. No need to modify any queries unless you yourself set or administrator has explicitly set the query_cache_type to DEMAND. By default the native query cache in MySQL is totally transparent to the end user. Anyway, I do see the value of having a cmysql driver for DB. -- Mika Tuupola http://www.appelsiini.net/~tuupola/