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
We have a similar issue arising and what we decided was to mirror the
database the users want to query so they are not dealing with "real time" or
production.. it gets mirrored twice a day 12pm and 12am so they have near
realtime data. Since its on the NAS it doesn't take long to mirror it. As
for
10 matches
Mail list logo
