-----------------------------
Please read the FAQ!
<http://java.apache.org/faq/>
-----------------------------
On Fri, Oct 01, 1999 at 11:06:35AM -0400, Tim Reilly wrote:
> Can anyone confirm this? Honestly, this scares the hell out of me.
> We're planning on using the IBM 1.1.8 JDK for Linux. In a perfect world,
> we'd be deploying on Solaris, but unfortunately we're a startup company
> and we just can't afford it as of yet.
> > You also need to be very careful about what queries you give to mysql. It
> > does not (at least did not) handle concurrent queries; ie. it finishes one
> > before starting the next, so a single expensive query can kill the whole
> > site for some time, make things backup, etc. As long as everything is an
> > easy select that can be done via indexes, things are reasonable but it
> > requires careful design of accesses and updates.
I haven't tried the IBM JVM, but this bit about MySQL is
wrong. MySQL, AFAIK, uses reader/writer locks, so multiple reads
can happen at once, regardless of the time they each tack to
complete.
Updates (writes) _do_ lock tables, but unless you're
doing something like a six-table join during an update, they're
very, very fast.
--
Robert Crawford [EMAIL PROTECTED]
http://www.iac.net/~crawford
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]