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