yes, search the archives for "WOT: MySQL in the Enterprise"
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 14:30
To: '[EMAIL PROTECTED]'
Subject: RE: [ cf-dev ] Confusing SQL
i'll did it out for ya :-) I
i'll did it out for ya :-) I am sure it was on CF-TALK..
-Original Message-
From: Tim Blair [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 14:30
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Confusing SQL
> yep, but as in a post a while ago, they have a long way to go
>
> yep, but as in a post a while ago, they have a long way to go
> before they are anywhere near Enterprise level, still good though!
Where be this post? Anyone got any other info on enterprise-level
hosting with MySQL?
Tim.
---
OUR NEW SITE
i still find it better than access.
- Original Message -
From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 16, 2003 1:35 PM
Subject: RE: [ cf-dev ] Confusing SQL
> yep, but as in a post a while ago, they hav
yep, but as in a post a while ago, they have a long way to go before they
are anywhere near Enterprise level, still good though!
-Original Message-
From: Tom Smith [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 13:15
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] Confusing SQL
which I
> The database is actually MySQL and whilst I could and should
> cache the
> circuits query this is only hit once as I call the other 2
> queries from
> within the output of the circuits query and hence cannot
> cache them as
> their result is dependent on a var which changes each time
> the
which I might add will change in a future official release...
- Original Message -
From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 16, 2003 1:06 PM
Subject: RE: [ cf-dev ] Confusing SQL
> I think you are do
I think you are doing the best you can with mySQL considering you have
no SP's, views etc... :-)
-Original Message-
From: Dave Phipps [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 13:09
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Confusing SQL
The database is actually MySQ
The database is actually MySQL and whilst I could and should cache the
circuits query this is only hit once as I call the other 2 queries from
within the output of the circuits query and hence cannot cache them as
their result is dependent on a var which changes each time the loop is
executed.
It could also be a flawed DB Schema. Has it been normalized effectively?
-Original Message-
From: Dave Phipps [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 12:42
To: ColdFusion User group
Subject: [ cf-dev ] Confusing SQL
Hi,
I have three queries that build a navigation system whic
if you are using SQL Server, you could bung it all into an SP and let that
do the work, giving you a nice need end result
-Original Message-
From: Paul Johnston [mailto:[EMAIL PROTECTED]]
Sent: 16 January 2003 12:48
To: [EMAIL PROTECTED]
Subject: RE: [ cf-dev ] Confusing SQL
Oh and
Oh and the suggestion would be (if the circuits/menus don't change too
much):
Cache the queries
This way the database doesn't get hit so much. The content may change too,
but it might be useful to have, for example, a 10 or 30 minute cache on
those too. Just to take the load off.
Paul
> Hi,
>
You haven't told us which DB your using (although from memory I think it's
Access yes?)
Paul
>
> I have three queries that build a navigation system which is
> running really
> slowly. This is because I haven't been able to combine the
> three queries
> into one and therefore have to do nes
13 matches
Mail list logo
