Hi! I can disclose that there is actually some progress being made in stored procedures + triggers.
Regards, Heikki Innobase Oy ----- Original Message ----- From: ""Jon Frisby"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, April 16, 2002 2:12 AM Subject: RE: MySQL and stored procedures -> v4.1 :( > > > When it's ready. > > > > That's a tautological answer. > > You've already stated your lack of belief in the reliability of deadlines, > so what did you expect? If someone had responded with "4.1 will be done on > 5/1/2002" you'd respond that the only way that would happen would be if it > were horribly buggy or lacked "critical" features -- if you hold such a > belief then no estimate would be meaningful because the "critical" feature > likely to be dropped to maintain the deadline would be stored procedures, > thus rendering any estimate worthless to you. > > > > > > Let's say I need to do 10 millions inserts. In what way will bundling > > > > all these 10 million inserts into one single batch give me some gain? > > > > > > Bundling them into batches of say 1,000 will minimize the number of disk > > > operations MySQL must perform. > > > > Well, but now the claim was to bundle all the little small bundles to one > > big bundle to increase performance. So saying that I now should make the > > big bundle into a little bundle is not really confirming with the original > > statement - rather contradicting it. > > I made the (apparently false) assumption that you wanted a more pragmatic > answer. Yes, you can batch them all in one and achieve a greater degree of > the same affect -- minimizing the number of I/O operations MySQL must > before -- but then one must be careful to not hit various buffer/memory pool > size limitations. I forget which particular ones would be meaningful here, > but it would be easy to (for example) exceed the size of your transaction > logs if you're doing 10 million write operations in a single transaction. > > > > That's only your opinion in the question and has nothing to do > > with the real facts. > > So anything you disagree with is an opinion, and not a fact? > > > -JF > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
