Re: Intermitent join problems

2002-11-20 Thread Heikki Tuuri
ase? Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query ... Subject: Intermitent join problems From: Frank Tuvell Date: Tue, 19 Nov

Re: Intermitent join problems

2002-11-20 Thread Heikki Tuuri
ase? Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query ... Subject: Intermitent join problems From: Frank Tuvell Date: Tue, 19 Nov

Intermitent join problems

2002-11-19 Thread Frank Tuvell
I'm using PHP 4.22, MySQL 3.23.53a on a RedHat Apache web server. I have a join that 99.9% of the time works fine but there have been 3 occasions in the last few weeks where extra records have found their way into the resulting dataset. This has happened during high load times. The join is a