Toilet Money

I ought to be a contractor and make some millions from toilets and their wonderful gadgets. What was I thinkin'? ;)

MySql Stored Procedure & query_cache

I 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.

666

I'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.

Covalentia

I'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:

• You must be a C# .Net programmer, preferrably intermediate level
• You must posses an original or a licensed Microsoft Visual Studio 2005
• .Net Framework 2.0
• IIS 5++
• Microsoft SQL Server 2000/MSDE or MySql Server 5.0
• You must be a girl, preferrably single (or single mother) - I'm just kiddin' :)
  

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.

Late Bloomer

I hope this time it'll work. I have much to write but so lil time to do so.