Thanks for all the response.
I've been doing quite a bit of research on it and
what it will take to get out of some of the habits
I've developed with CF TRANSACTION etc.
The main thing I'd like to see, is an example of the
correct process for table locking across multiple
queries in CF. Maybe I'm just being a little thick.
Do you . . .
<cf query name="lockmytables" data source="Dan">
Lock table
</cf query>
<cf query> a query </cf query>
<cf query> another dependent query</cf query>
<cf query name"unlockmytables">
unlock tables
</cf query>
Thanks,
Shahn
--- Mats Stromberg <[EMAIL PROTECTED]> wrote:
> To me MySQL isn't an alternative, it is the one! :)
> we've been running it for some years now and it
> really runs nice and
> extremely fast.
> Transactions have never been a problem for us, a lot
> due to the stability
> of the product. Not one single crash.
> This is of course an issue for many and MySQL has
> addressed this and the
> current version of MySQL do support transaction.
> Unfortunately I can't give you any feedback on how
> good or bad this works
> or affects the performance of the engine.
> Maybe someone else has some experience with this new
> feature of MySQL?
>
> /Mats/
> At 05:00 AM 3/15/2001 -0800, you wrote:
> >Sorry for the AT, but I'm just curious as to
> weather
> >or not anyone is using mySQL and their opinions
> about
> >using it as an alternative to SAL Server ($$$$$$).
> >
> >I've been doing some testing with table locking
> etc.
> >but I would be very interested in hearing how
> others
> >are coding around transactions.
> >
> >Shahn
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
