After using MS SQL Server for years today we're using MySQL for a CF website project. What's the best table type for that project: InnoDB(transaction MySQL table) or MyISAM(no transaction)? Why?
Thanks
--
___
Sign-up for Ads Free at Mail.
I use InnoDB because it supports foreign keys and that is a huge help when
you don't have one of the other major DB's available!
HTH
Donnie Bachan
Phone: (718) 217-2883
ICQ#: 28006783
"Nitendo Vinces - By Striving You Shall Conquer"
[Todays Threads]
[This Message]
[Subscription]
[Fast Uns
What kind of percentage rates did you get from payquake?
Dan
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Monday, December 22, 2003 5:23 PM
To: CF-Talk
Subject: Re: OT: online credit card processing and merchant accounts
I used payquake (www.payquake.com) to set u
If you need transactions, use InnoDB.
-Original Message-
From: Spectrum WebDesign [mailto:[EMAIL PROTECTED]
Sent: December 24, 2003 4:56 AM
To: CF-Talk
Subject: OT - MySQL - MyISAM or InnoDB
After using MS SQL Server for years today we're using MySQL for a CF website
project. What's the
Thanks Mike...Where can i find Macromedia FlashPaper component? Macromedia
Site?
Regards
__
MSc. Hassan Arteaga Rodríguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.
_
From: Mike Brunt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 23, 2003 04:3
Hi All,
I have a quick question:
I have piece of code below:
INSERT INTO tbl_Main (adadadadadadadada)
VALUES (dadadadadadad)
SELECT MAX ID from tbl_Main
Is Flash Paper a separate component or do you need to use a certain version of Flash or Dream weaver to use it.
Thanks
Mario
-Original Message-
From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 24, 2003 10:55 AM
To: CF-Talk
Subject: RE: RE: PDF on Fly
T
> Is Flash Paper a separate component or do you need to use a
> certain version of Flash or Dream weaver to use it.
FlashPaper comes with Contribute 2, I think, and I don't think there's any
way to get it separately. You can use it with Flash 6 or higher, at least,
and may be able to use it with
> I have piece of code below:
>
>
>
> INSERT INTO tbl_Main (adadadadadadadada)
> VALUES (dadadadadadad)
>
>
> SELECT MAX ID from tbl_Main
>
>
>
Right now Flash Paper comes with Contribute only.
--- Ben
-Original Message-
From: Ciliotta, Mario [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 24, 2003 11:03 AM
To: CF-Talk
Subject: RE: RE: PDF on Fly
Is Flash Paper a separate component or do you need to use a certain
version
"If you're using SQL Server 2000, on the other
hand, this may not be sufficient, since SQL Server 2000 can lock individual
records. So, in that case, you'd want to specify a stricter isolation level,
such as "serializable". You can do this using the ISOLATION attribute of
CFTRANSACTION"
Actually,
> Actually, you can only suggest isolation levels to DB, the DB
> is the one that sets isolation levels and does what it think
> is the best thing.
While I imagine this could be true for some database, it certainly isn't
true for either SQL Server or Oracle. I don't even think it's true for
loc
> > Actually, you can only suggest isolation levels to DB, the DB
> > is the one that sets isolation levels and does what it think
> > is the best thing.
>
> While I imagine this could be true for some database, it certainly isn't
> true for either SQL Server or Oracle. I don't even think it's true
InnoDB is nice for the transactions and foreign key support (though as
Jochem points out every time, it's not technically complete). However, it's
100% usable. MyISAM are really fast, and easier to work with for backups
and stuff that InnoDB, because the tables are stored on the filesystem
direct
I hope someone at MM is listening. I just tried to read ColdFusion MX 6.1
Evaluator's Guide
aluators_guide.pdf> as a PDF file from here
http://www.macromedia.com/software/coldfusion/whitepapers/ and after the
usual painful PDF browser wait got a blank screen which appeared frozen in
time. I a
Some locking hits are row based:
SELECT column
FROM table WITH (ROWLOCK).
-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: December 24, 2003 10:23 AM
To: CF-Talk
Subject: Re: CFTRANSACTION & CFLOCK
> > Actually, you can only suggest isolation levels to DB, the DB
No, serializable is not the default level. Automatically serializing
transactions would be a huge performance killer.
-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: December 24, 2003 9:55 AM
To: CF-Talk
Subject: RE: CFTRANSACTION & CFLOCK
"If you're using SQL Server
Thanks all and you Barney. Great explanation.
Cheers
- Original Message -
From: "Barney Boisvert" <[EMAIL PROTECTED]>
Date: Wed, 24 Dec 2003 09:23:30 -0800
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: OT - MySQL - MyISAM or InnoDB
InnoDB is nice for the transactions and foreign key suppo
Well, in fact, you probably will need cflock around this _if_ the database
does not support serialized transactions.
But then again, doing this method if getting the primary key is stupid,
stupid, stupid.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: December 24,
> Well, in fact, you probably will need cflock around this _if_
> the database does not support serialized transactions.
I think this would depend on the granularity of the locks within the
database. If you were using Access, again, I think this would work fine with
the default isolation level of
I am just saying what I read in "Certified Cold fusion developer study guide" by Ben Forta. page 161 top - "SERIALIZABLE is the highest isolation level provided by a database and is the defalut." If you are absolutely sure that this is not the case tell Ben about it.
TK
- Original Message ---
Ooops I meant "suggest locking" not "suggest isolation levels". You can of course set isolation levels in CF and this is the way CF recommends locking type to the DB.
TK
-Original Message-
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: December 24, 2003 10:23 AM
To: CF-Talk
Subject:
> Ooops I meant "suggest locking" not "suggest isolation
> levels". You can of course set isolation levels in CF and
> this is the way CF recommends locking type to the DB.
Again, though, I don't think this is a recommendation - I'm pretty sure that
whatever you choose for your isolation level w
Tom Kitta wrote:
> I am just saying what I read in "Certified Cold fusion developer study guide" by Ben Forta. page 161 top - "SERIALIZABLE is the highest isolation level provided by a database and is the defalut." If you are absolutely sure that this is not the case tell Ben about it.
The standar
Believe it or not, the book is wrong.
-Original Message-
From: Tom Kitta [mailto:[EMAIL PROTECTED]
Sent: January 8, 2004 1:15 PM
To: CF-Talk
Subject: Re: CFTRANSACTION & CFLOCK
I am just saying what I read in "Certified Cold fusion developer study
guide" by Ben Forta. page 161 top - "SER
Well, this isn't strictly true either. Some databases can escalate locks
above what you've specified - this is usually a good thing though.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: December 24, 2003 1:32 PM
To: CF-Talk
Subject: RE: CFTRANSACTION & CFLOCK
> Ooo
> > > Ooops I meant "suggest locking" not "suggest isolation
> > > levels". You can of course set isolation levels in CF and
> > > this is the way CF recommends locking type to the DB.
> >
> > Again, though, I don't think this is a recommendation - I'm
> > pretty sure that whatever you choose f
that's rather strange... iirc the error generated in the template
specified by cferror should be identical to any error that would be
generated by cfthrow-cfcatch. You might rewrite it temporarily with
throw-catch to test and see what results you get.
> It seems I can't pass a CFTHROW "errorCode"
Here as well:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a10.htm#wp
3395038
> http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/err
> ors8.htm
> -Original Message-
> From: Kevin Marino [mailto:[EMAIL PROTECTED]
> Sent: dinsdag 23 december 2003 16:20
> To: CF-Talk
> S
May not be a CF issue per se... I suspect they've got separate
permissions somewhere that prevent java from accessing the network
like a firewall. Though if it were a firewall issue, I'd expect
something different as an error, like timeout... this isn't really my
area, I'm just throwing out ideas.
I'd be willing to bet that there's no way around having your scheduled
tasks show up in the cfadmin ide in MX ... You're probably better off
finding a 3rd-party http tool you can use with the Windows task
scheduler. Since that won't be managed by the CF engine, it won't show
up in the administrator
> Some locking hits are row based:
>
> SELECT column
> FROM table WITH (ROWLOCK).
i stand corrected.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
32 matches
Mail list logo