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 facing an old application
written in PHP4 with PostgreSQL, and because of vacuum() it's having a big
troubles. Solution? Straightforward: replace PostgreSQL with MySQL.
Even with plain MyISAM tables, without heap tables (for storing session
information - bascically cookies etc.) it's already faster and more robust
(because of no need for vacuum() in MySQL). I think that heap tables would
boost the performance even more.
> > I have some tables in the database which I would like to create as
> > TYPE=HEAP in MySQL. Because I have read the MySQL manual (applause
> > here, please!) I know that auto_increment cannot be used there.
> > This hurts me a lot, and given that MySQL doesn't support sequences,
> > it nearly prohibits the usage of heap tables in my application.
>
> You do know that HEAP tables exist only in memory, right?
No applause for me reading the manual? That's a pity! ;-)
> > However, I am still not giving up, so here's the question: how
> > difficult would it be to get rid of that restriction for
> > auto_increment in heap tables? The ideal answer I am hoping for is
> > 'yeah, that's easy - wait for 3.23.42' or 'try this patch and let us
> > know if it works for you'.
>
> I don't think it's easy, but I know only bits about the internals so
> far.
>
> My understanding is that the AUTO_INCREMENT feature is tied to the
> index in some way. And HEAP tables use a hash-based index for primary
> keys rather than a tree-based index. That's not to say it's
> impossible--it's not. There are ways it could work (in theory). I
> suspect, though, that it's not a quick patch.
Well, thank you for the response anyway, even when it's not good for me.
It's the only response I got so far.
Thanks again,
Leos
---------------------------------------------------------------------
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