On Thu, Apr 23, 2009 at 9:41 AM, Ian Skinner wrote:
>
> Michael Grant wrote:
> > How often does your dba create/tweak indexes?
>
> I am not sure, database performance tuning is a top item on my
> discussion list.
>
If this is purely a reporting database, consider batch-generating a set of
can
>
> I am not sure, database performance tuning is a top item on my
> discussion list.
+1
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;2
Michael Grant wrote:
> How often does your dba create/tweak indexes?
I am not sure, database performance tuning is a top item on my
discussion list.
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release
Michael Grant wrote:
> What db are you using? How often does your dba create/tweak indexes?
Oracle 11g enterprise. We just recently finished a *HUGE* upgrade to
get the system from CF4.5/Oracle 7i to CF8/Oracle 11ge
~|
Adobe®
What db are you using? How often does your dba create/tweak indexes?
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
A
Can't you set a query timeout ?
-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com]
Sent: Thursday, April 23, 2009 11:14 AM
To: cf-community
Subject: Re: YIKES! I must let internet users write SQL queries for our
database!
Ian Skinner wrote:
> Did I get your a
.
-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com]
Sent: Thursday, April 23, 2009 11:07 AM
To: cf-community
Subject: Re: YIKES! I must let internet users write SQL queries for our
database!
Scott Raley wrote:
> Does this help?
A couple of questions about your post Scott? What is B
Ian Skinner wrote:
> Did I get your attention? Luckily these are read-only queries, but still!
I forgot to mention an important consideration is to somehow control and
mitigate query requests so that users don't tie up the database with a
task taking hours and hours to process.
It is already
Scott Raley wrote:
> Does this help?
A couple of questions about your post Scott? What is BIRT? Is that a
product or something? And are your "users" corporate users or something
like this where tools can be distributed to them?
The latter is not true for us. This is literally anybody in t
the COTS tool on their PC and run the
reports themselves.
Does this help?
-Original Message-
From: Ian Skinner [mailto:h...@ilsweb.com]
Sent: Thursday, April 23, 2009 10:35 AM
To: cf-community
Subject: YIKES! I must let internet users write SQL queries for our
database!
Cross post from
Cross post from cf-talk for those of you who may not monitor that list
as this is not necessarily a ColdFusion issue at this point.
Did I get your attention? Luckily these are read-only queries, but still!
I have a meeting this afternoon to discuss reworking/developing an
interface to allow an
11 matches
Mail list logo
