[TYPO3-dev] Fatal Query

[Peter Russ]

--- Original Nachricht ---
Absender:   Dan Osipov
Datum:       12.01.2009 22:46:
>  > If you run the query in phpmyadmin is there a way to reproduce the 
> problem?
> 
> Again, problem is random, so most times it works fine, so I was unable 
> to reproduce it in phpMyAdmin. Also, several people may be using the 
> NewsAdmin at the same time, causing several queries to go into 
> statistics simultaneously - which might be the cause of the issue.
[...]
> 
> AFAIK, count(*) and count(uid) are equivalent, since uid is a primary key.

You're right.
Instead of using replication for performance (InnoDB for insert/update 
as master, MyISAM for select as slave - not support sofar in TYPO3 ;-) 
PostgreSQL might be a solution.

Regs. Peter.



-- 
Fiat lux!
Docendo discimus.
http://www.gidf.de

_____________________________
4Many� Services

XING:	https://www.xing.com/go/invita/360052
	http://www.xing.com/go/privatemessage/Peter_Russ