Re: Perl vs Java - your feedback, not flames

Tarun Dua <[email protected]> Wed, 17 Nov 2004 16:43:58 +0530
Newsgroups gmane.user-groups.linux.delhi.devel
Organization Linux Delhi
Message-ID <[email protected]>
Sandip Bhattacharya wrote:
> If you are going to use anything more than simple independent
> insert/select queries, either use Mysql with Innodb (transactional
> support) or stick to Postgresql.
> I have burnt my fingers on mysql in my last project, and lack of
> transactional support in the default mysql packages is a big problem. 
> Lack 
> of referential integrity is another.
Another idea is to use the InnoDB tables only where you need referential
integrity and transaction support and let the rest of the tables use the
default myisam engine. Since there is going to be a lot searching in the
app. ( but not a lot of concurrent inserts ) go for myisam for a most of
the tables.
-Tarun
-- 
http://www.tarundua.net
Nothing you ever wanted to find about Tarun Dua