Currently browsing

December 22, 2012

Run any Stored Procedure from Net

Run any Stored Procedure from .Net NOTE: When I am tring to publish that post then getting some problem for HTML rendering so I replace two character. please replace these two character. HTML opening tag with * and HTML closing tag with $. Hi, Now I’m far from socket now …

Index of Materialized View Not Working

Index of Materialized View Not Working Introduction I got a mail from one of my closed friends related to “Materialized view Index not working”. I am little bit confused after getting this mail. When I am getting closer look at the problem that I understand what he mean by “Materialized …

Mass inserts updates SQLite vs MySQL update delayed inserts

Mass inserts, updates: SQLite vs MySQL (update: delayed inserts) pre { background-color:#444; white-space:pre-wrap; font-size:85%; padding:0px 6px; } Lessons learned: SQLite performs inserts 8-14 times faster then InnoDB / MyISAM SQLite performs updates 4-8 times faster then InnoDB and as fast as MyISAM SQLite performs selects 2 times faster than InnoDB …