Re: [Sqlgrey-users] Using PostgreSQL vs MySQL

[Dan F. <da...@ha...>]

Dave Strickler wrote:
> Very slick. We will definitely test this out on our end.
>  
> Are you using MyISAM or InnoDB for your table format? MyISAM seems too limited...
>   
We use MyISAM in practically all systems.

If i remember correctly the differences are that InnoDB does real 
transactions and row locking, and MyISAM runs faster.
However this is just as i recall and i didnt doublecheck. 
Also i seem to remember something about the license for InnoDB being 
commercial.
I dont think MyISAM is limited unless you need transactions.

- Dan Faerch




>  
> Dave Strickler
> MailWise LLC
> 617-933-5810 (direct)
> www.mailwise.com ( http://www.mailwise.com/ )
> "Intelligent E-mail Protection"
>
>
>
>
>
>   
>>>> Dan Faerch <da...@ha...> 3:23 PM Tuesday, May 30, 2006 >>>
>>>>         
> Dave Strickler wrote:
>   
>> Two followup questions:
>> 1. What table format do you use? MyISAM or InnoDB ?
>>   
>>     
> We use MyISAM and i believe it has become a pretty good table format.. 
> Eg. our logservers each handle just below 2 gigs of data a day in one 
> table and we never get messed up tables or other problems.
>