| Cozta Norhalim's profilecozta.netBlogLists | Help |
Toilet MoneyI ought to be a contractor and make some millions from toilets and their wonderful gadgets. What was I thinkin'? MySql Stored Procedure & query_cacheI was running some benchmarking and testing on MySql MyISAM and InnoDB database engines when I suddenly realized that the queries executed by MySql weren't cached, ie. the qcache_hits variable wasn't hit or get incremented. Apparently, if a stored procedure has one or more parameters (for example, sp_query_not_cache (int i)), the queries are not cached. Hmm. So that means, not one of Covalentia's many queries to the database will be cached. Oh well. 666I've been terribly busy in the past few days trying to fix critical bugs that suddenly appeared out of no where in Covalentia. I've also added a few more caching features in the View page to make user experience friendlier which includes caching of the Search Criteria and Search Result during switching of tabs, provided that the cache dependencies for the data being viewed (cached) are still valid. The Edit Sub-Module is taking a long time to load if a table has too many fields or columns. I happen to have a table with 186 or so columns and the page size goes up to 7 freakin' MB. So, rule of thumb, do not put too many fields in one table. I have a long list of tasks or bugs for Covalentia in my outlook, and if somehow I could automatically export those tasks here, it'd definitely make my life easier. Hmm. CovalentiaI've finally decided to make Covalentia freely available/downloadable. The 2nd version of Covalentia, ie. Covalentia V.2.0.1 shall be released hopefully at the end of this month, if not, early next month (July). Anybody who's interested can download and try it out at http://www.covalentia.net (which will be upgraded soon, not now), help me fix the bugs, make it better by all means
The requirements are as follows:
Okay, now, where was I? Currently, I'm finalizing the Core Module and Features and fixing some of the critical bugs. More updates afterwards. Heh. |
|
|