Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Select count(*) in Oracle and MySQL

Re: Select count(*) in Oracle and MySQL

From: <sybrandb_at_hccnet.nl>
Date: Wed, 19 Sep 2007 23:03:29 +0200
Message-ID: <6j33f3hqu23bebkecb2hen0c6gsntus9s0@4ax.com> 





On 19 Sep 2007 20:10:12 GMT, Jerome Vitalis
<vitalismanN05P4M_at_gmail.com.invalid> wrote:



>It's all in the doco of MySQL. count(*) is optimized with MyISAM *only*. 

>And MyISAM is not transaction-safe.




MySQL aficionados probably don't read documentation and don't care
about transaction safety.


Likely MySQL will *never* come out of the Kindergarten.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Wed Sep 19 2007 - 16:03:29 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US