tag:blogger.com,1999:blog-5430866.post5419426473375020934..comments2024-01-02T08:54:14.406-05:00Comments on Peter Bromberg's UnBlog: SQLite, ADO.NET, Prepared Statements, Transactions and Enterprise Managerpeterbromberghttp://www.blogger.com/profile/18173639411723574123noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-5430866.post-71200015294157338612011-09-29T02:13:29.479-05:002011-09-29T02:13:29.479-05:00This was a great article.
I still don't know w...This was a great article.<br />I still don't know why creating a string with heaps of inserts and doing one ExecuteNonQuery() is so much slower than your method. I used transactions and everything!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5430866.post-6747399690821230392010-01-29T03:02:03.105-05:002010-01-29T03:02:03.105-05:00Peter Bromberg you are q wonderfull man thanks for...Peter Bromberg you are q wonderfull man thanks for everything.I learn a lot of things.Thank you very muchbozokhttps://www.blogger.com/profile/04603693855451057948noreply@blogger.comtag:blogger.com,1999:blog-5430866.post-72531558988188149732010-01-27T10:30:57.394-05:002010-01-27T10:30:57.394-05:00Thanks for the tips :)
I use this syntax for prep...Thanks for the tips :)<br /><br />I use this syntax for prepared statements:<br />cmd.CommandText="Insert Into Table (Col1) Values (@col1);";<br />cmd.Parameters.Add("@col1", SqlDbType.Int64).Value=1000L;<br />--------<br />it's sorta like MSSQL SPs :DMahdi Saffarihttps://www.blogger.com/profile/01152949748884543297noreply@blogger.comtag:blogger.com,1999:blog-5430866.post-46839941762206517502009-09-27T17:30:09.376-05:002009-09-27T17:30:09.376-05:00Thanks!!! Your article was very helpful!Thanks!!! Your article was very helpful!Anonymoushttps://www.blogger.com/profile/11765624223769267339noreply@blogger.comtag:blogger.com,1999:blog-5430866.post-53856627924667597812009-09-27T10:43:37.532-05:002009-09-27T10:43:37.532-05:00The equivalent of a "prepared statuement"...The equivalent of a "prepared statuement" in SQLite is: cmd.CommandText = "INSERT INTO TestCase(MyValue) VALUES(?)";peterbromberghttps://www.blogger.com/profile/18173639411723574123noreply@blogger.comtag:blogger.com,1999:blog-5430866.post-84578481578735891922009-09-27T10:38:23.129-05:002009-09-27T10:38:23.129-05:00I understand that this is faster, but I can't ...I understand that this is faster, but I can't see the prepared statement. Did you forget it or it was on purpose?Anonymoushttps://www.blogger.com/profile/11765624223769267339noreply@blogger.comtag:blogger.com,1999:blog-5430866.post-90600724222151641472009-05-05T10:53:00.000-05:002009-05-05T10:53:00.000-05:00Thanks for the tip, I knew something was wrong whe...Thanks for the tip, I knew something was wrong when it took me over 10 seconds to insert 240 records :)Jeff McKeandhttps://www.blogger.com/profile/17497010822154000799noreply@blogger.comtag:blogger.com,1999:blog-5430866.post-54232000080557594252008-09-11T00:54:00.000-05:002008-09-11T00:54:00.000-05:00I've been searching a very long time to do this.. ...I've been searching a very long time to do this.. Dude .. You Rock!!<BR/><BR/>I'm standing with my hands on my hips doing a pirate-like laugh after inserting 1.2 mil records in under 20 secFoxiBoyhttps://www.blogger.com/profile/01226315409772553382noreply@blogger.comtag:blogger.com,1999:blog-5430866.post-7045539052530501942008-05-11T10:27:00.000-05:002008-05-11T10:27:00.000-05:00Yes, the guy apparently gave up his domain. I have...Yes, the guy apparently gave up his domain. I have the last version of it, but his latest version was "for pay" and so I don't feel comfortable distributing it. I'm leaving the link up in hopes that he "comes back".peterbromberghttps://www.blogger.com/profile/18173639411723574123noreply@blogger.comtag:blogger.com,1999:blog-5430866.post-82264729637812295292008-05-11T08:46:00.001-05:002008-05-11T08:46:00.001-05:00Thank you for you articles.I find them very useful...Thank you for you articles.<BR/>I find them very useful!<BR/>Keep up the good writing!<BR/><BR/>Ah, maybe this isn't the wright place but <BR/>the link behind "SQLITE PRO Enterprise Manager." is dead.. (I couldn't connect to it.)<BR/><BR/>Kind regardsAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5430866.post-24832778131032730132007-12-18T10:22:00.000-05:002007-12-18T10:22:00.000-05:00Great post! Keep up the good work.Great post! Keep up the good work.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5430866.post-83996984668001015672007-06-04T16:36:00.000-05:002007-06-04T16:36:00.000-05:00Thanks for this great article. I didn´t always use...Thanks for this great article. I didn´t always use transactions - now I do ;-)Anonymousnoreply@blogger.com