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
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
Hi,
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 nested loops which results in about 50
queries running for some sections of the site.
The three queries
14 matches
Mail list logo
