It depends on your solution....if you are building the next
Etrade, I may not recommend it....if you are building a web site that does
what 95% of the population is doing...then it is great.
At 07:08 PM 9/29/00 -0700, you wrote:
>Can you please give me more information regarding your use of MySQL with
>Orion?
I am using a connection pool...currently one from javaexchange.com, just
because I've used it for years and it has worked for me.....I don't have
mission critical data, however, I am still pretty confident with my
setup. I'm sure orion's connection pooling is good......for
javaexchange's, I had to reconnect=true and all is well.
>Any problems at all?
None yet, except sometimes I think that some of this code is too forgiving,
I'm always forgetting to close resultsets and statements and there never
seems to be a problem... :)
>Does it support Transactions now?
I've heard yes, but haven't tested..see for yourself:
http://www.mysql.com/downloads/mysql-3.23.html
It is in late beta...I think.
>Is it still as blazingly fast as it was without transactions?
not sure...but mysql is fast in general
>Any difficulties getting it to work with Orion, or is it a standard
>installation?
not at all, just make sure you have drivers
(http://www.worldserver.com/mm.mysql/) in orion's classpath.
I recommend using MYSQL or Oracle, why settle for anything else? And the
only reason I say Oracle is that it is a valuable skill....I'll switch to
oracle if I have a terabyte DB I need to distribute, but my data is not
like that at all.....currently handling about 100k selects/updates daily
David
