85 messages in com.mysql.lists.mysqlRe: Default forced on MySQL
FromSent OnAttachments
Kodrik06 Nov 2001 22:28 
DownloadFAST.com07 Nov 2001 00:35 
Arne K. Haaje07 Nov 2001 01:05 
DownloadFAST.com07 Nov 2001 01:26 
Kodrik07 Nov 2001 01:31 
Kodrik07 Nov 2001 01:34 
DownloadFAST.com07 Nov 2001 01:45 
Kodrik07 Nov 2001 01:59 
DownloadFAST.com07 Nov 2001 02:43 
Kodrik07 Nov 2001 02:44 
Kodrik07 Nov 2001 02:53 
Elm Gysel07 Nov 2001 02:59 
DownloadFAST.com07 Nov 2001 03:16 
DownloadFAST.com07 Nov 2001 03:36 
Kodrik07 Nov 2001 03:46 
Carsten H. Pedersen07 Nov 2001 04:02 
DownloadFAST.com07 Nov 2001 04:05 
DownloadFAST.com07 Nov 2001 04:13 
DownloadFAST.com07 Nov 2001 04:46 
Carl Troein07 Nov 2001 04:54 
Kodrik07 Nov 2001 05:06 
DownloadFAST.com07 Nov 2001 05:20 
Sinisa Milivojevic07 Nov 2001 05:34 
DownloadFAST.com07 Nov 2001 05:53 
DownloadFAST.com07 Nov 2001 06:25 
Sinisa Milivojevic07 Nov 2001 06:29 
DownloadFAST.com07 Nov 2001 06:35 
DownloadFAST.com07 Nov 2001 06:46 
DL Neil07 Nov 2001 06:52 
DownloadFAST.com07 Nov 2001 07:01 
DownloadFAST.com07 Nov 2001 07:08 
Sinisa Milivojevic07 Nov 2001 07:13 
Elm Gysel07 Nov 2001 07:23 
DownloadFAST.com07 Nov 2001 07:27 
Sinisa Milivojevic07 Nov 2001 07:28 
DownloadFAST.com07 Nov 2001 07:31 
DownloadFAST.com07 Nov 2001 07:35 
DownloadFAST.com07 Nov 2001 07:47 
Sinisa Milivojevic07 Nov 2001 08:20 
Scott Thurmond07 Nov 2001 08:28 
Sinisa Milivojevic07 Nov 2001 08:29 
Elm Gysel07 Nov 2001 08:30 
Paul DuBois07 Nov 2001 08:45 
DownloadFAST.com07 Nov 2001 09:02 
DownloadFAST.com07 Nov 2001 09:08 
DownloadFAST.com07 Nov 2001 09:29 
Sinisa Milivojevic07 Nov 2001 09:47 
DownloadFAST.com07 Nov 2001 09:49 
DownloadFAST.com07 Nov 2001 10:01 
Paul DuBois07 Nov 2001 10:18 
rc07 Nov 2001 10:48 
Shankar Unni07 Nov 2001 11:17 
DownloadFAST.com07 Nov 2001 12:48 
Kodrik07 Nov 2001 13:53 
Ravi Raman07 Nov 2001 14:16 
Paul DuBois07 Nov 2001 14:37 
Shankar Unni07 Nov 2001 15:52 
Kodrik08 Nov 2001 01:02 
Kodrik08 Nov 2001 01:02 
DownloadFAST.com08 Nov 2001 04:54 
DownloadFAST.com08 Nov 2001 06:53 
Gordan Bobic08 Nov 2001 08:18 
DownloadFAST.com08 Nov 2001 19:30 
Gordan Bobic09 Nov 2001 02:54 
DownloadFAST.com09 Nov 2001 03:37 
DownloadFAST.com09 Nov 2001 04:11 
Gordan Bobic09 Nov 2001 05:07 
Gordan Bobic09 Nov 2001 05:09 
Shankar Unni09 Nov 2001 11:31 
Kodrik09 Nov 2001 12:39 
Franklin Schmidt10 Nov 2001 01:50 
Franklin Schmidt10 Nov 2001 01:56 
Franklin Schmidt10 Nov 2001 02:31 
Kodrik10 Nov 2001 02:56 
Franklin Schmidt10 Nov 2001 12:59 
Kodrik10 Nov 2001 13:52 
Arjen G. Lentz10 Nov 2001 15:27 
Kodrik10 Nov 2001 15:50 
Gordan Bobic10 Nov 2001 18:34 
Phieu Huynh11 Nov 2001 16:31 
M.Ho...@gac.nl12 Nov 2001 01:51 
Nguyen Trong Phuc12 Nov 2001 16:25 
Phieu Huynh12 Nov 2001 22:19 
Franklin Schmidt14 Nov 2001 06:44 
Christopher Book14 Nov 2001 07:58 
Subject:Re: Default forced on MySQL
From:DownloadFAST.com (supp@DownloadFAST.com)
Date:11/07/2001 07:08:23 AM
List:com.mysql.lists.mysql

Okay limit it to 1 table then.

The main focus on MySQL (as I understand it and has been reiterated today) is many, many fast selects, and very few simple updates.

It seems that the insert into single table very infrequently but with better adherence to schema rules, is right in line with the audience (even if that audience doesn't want to admit we all have bugs we don't currently know about...denial is bliss).

Or are you saying there is very little chance this will be improved ever for MyISAM or definitely not soon??

(BTW, the only reason I brought this discussion to the list, was because there was no place on the web site to ask about paying to add a feature before actually paying. I think it is not good business to ask someone to pay before they can ask pre-sales questions)

At 04:30 PM 11/7/2001 +0200, you wrote:

DownloadFAST.com writes:

Thanks for the informative reply.

SUGGESTION: Since the rollback optimization problem does NOT apply to single inserts, then why butcher the schema, and instead just make the automatic defaults a "feature" of multiple row inserts??

In other words, why penalize the single row insert (the most common) just because of the optimization issue with multi-row inserts?

<JOKE>Hey I feel like we are actually helping each other now. What a wonderful concept</JOKE>

Sincere thanks.

You are welcome !

Automatic defaults can not be a feature of just multiple row inserts, as there are other commands ( i have mentioned one in my previous mails) that can not be stopped in the middle of operation on non-transactional tables.

Even single row inserts have to use this `feature`. User could be inserting into several tables, so a fail in one table could be circumvented with rollbacks only, as tables could be related. And again, MyISAM operations can not be rolled back, so we are back at the beginning.

-- Regards, __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sin@mysql.com> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com