ot;Andrew Schmidt" <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>
>Sent: Thursday, August 16, 2001 12:50 PM
>Subject: Re: auto_increment vs. heap tables
>
>
> > Uh oh... Please NO. I want the standard _FAST_ auto_increment, not this.
> > "select max(id
#x27;" <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 1:02 PM
Subject: RE: auto_increment vs. heap tables
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Except, if you have a table like so:
>
> ++-+
> | id | num |
> ++-+
> |
ct the
max(sess_id).
well anyway, sorry I couldn't help more.
thanks,
-- Andrew
- Original Message -
From: "Leos Bitto" <[EMAIL PROTECTED]>
To: "Andrew Schmidt" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 12:50 PM
Uh oh... Please NO. I want the standard _FAST_ auto_increment, not this.
"select max(id) from table x" is terribly inefficient. And the table
is locked during this operation... That's just not acceptable for me.
Anyway, thanks for the response. It was the second one.
Leos
On Thu, 16 Aug 2001, An
auto increment is really just a nice way of doing the following (really nice
way actually):
lock table x
select max(id) + 1 from table x
insert into table x values (newid)
unlock table x
this is under the assumption table x as 1 field called id which has a
primary key on it. and newid is the id
On Wed, 15 Aug 2001, Jeremy Zawodny wrote:
> On Tue, Aug 14, 2001 at 12:05:08PM +0200, Leos Bitto wrote:
> > Hello,
> >
> > I am currently changing a simple PHP4-based application from
> > PostgreSQL 7.1 to MySQL 3.23.
>
> Welcome to MySQL, then. :-)
I am already using MySQL a lot, and now I am
On Tue, Aug 14, 2001 at 12:05:08PM +0200, Leos Bitto wrote:
> Hello,
>
> I am currently changing a simple PHP4-based application from
> PostgreSQL 7.1 to MySQL 3.23.
Welcome to MySQL, then. :-)
> I have some tables in the database which I would like to create as
> TYPE=HEAP in MySQL. Because I
