On Mon, Sep 03, 2001 at 12:50:39PM +0200, Stephan wrote:
>
> >> My problem with the REPLACE is that the documentation says that a
> >> REPLACE always does an DELETE and then an INSERT. In my case a lot
> >> of rows (99%) would be deleted in the index that only need an
> >> update. Is it a good idea to do that much index manipulations that
> >> aren't necessary?
>
> > Hmm. Are you asking for performance reasons or just because one is
> > easier to code than the other?
>
> I'm just afraid that the system get's damages Index-files when I do
> that much unnecessary index-updates. At the moment we get about
> one damaged file in 2 months (isamcheck). But this replace
> operation will increase index-manipulation dramatically.
That shouldn't happen. Try MyISAM tables with a recent MySQL. If you
see corruption, it's a bug that the MySQL developers will fix if you
can provide a repeatable test case.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 3 days, processed 33,919,448 queries (109/sec. avg)
---------------------------------------------------------------------
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
