On Monday 24 Sep 2007, [EMAIL PROTECTED] wrote:
sounds like a job for a staging table just for inserts w/out any indexes
which moves the data via triggers or whatever to real tables for
maintenance querying.
Yup, had multiple staging databases (local to the things making the millions
of
On Friday 21 Sep 2007, [EMAIL PROTECTED] wrote:
You are correct in that the proper indexes will certainly increase
performance.
Increase *select* performance if the index is used.
Indexes make insert/update slower.
I used to work on a DB that had over a million inserts a month, with 'only'
Tom Chiverton wrote:
Indexes make insert/update slower.
yup.
I used to work on a DB that had over a million inserts a month, with 'only'
several (tens of) thousend selects. We got better performane on the insert by
dropping some indexes, and the select performance was only slightly worse.
In general when using a relational database for client data storage, is
it a good idea to archive data older than a certain date (like say 2
years) or just let good indexes take care of data growth?
For example, we would move all data out of certain tables that grow very
large (approx. 20K - 40K
them together.
If you don't need online access to the data, then you can archive it.
M!ke
-Original Message-
From: James Davis [mailto:[EMAIL PROTECTED]
Sent: Friday, September 21, 2007 3:00 PM
To: CF-Talk
Subject: Archiving SQL table data
In general when using a relational database
What database are you using? Any enterprise DBMS is built to handle millions
of records. If its running on decent hardware there should be no problem.
Given your scenario, there seems to be no reason to worry about archiving your
data into other tables. 20k-40k records is nothing.
Steve
Systems, Inc.
-Original Message-
From: Steve Milburn [mailto:[EMAIL PROTECTED]
Sent: Friday, September 21, 2007 4:10 PM
To: CF-Talk
Subject: Re: Archiving SQL table data
What database are you using? Any enterprise DBMS is built to handle millions
of records. If its running on decent
on this.
Cheers mate,
Rob
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: 07 May 2007 17:23
To: CF-Talk
Subject: RE: Table Data
Hmmm. Well, I checked the HOUR() function and it returns 0-23 for the
hours as I hoped.
I just tried a simple test and it worked
with the
GROUP BY, then the outer SELECT would only need to add the hour of day
value.
M!ke
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 08, 2007 2:33 AM
To: CF-Talk
Subject: RE: Table Data
Morning Mike,
I think part of the problem
months of
the year :-D
Thanks again pal,
Rob
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: 08 May 2007 13:05
To: CF-Talk
Subject: RE: Table Data
That's good to hear.
BTW, you may be able to simplify this a bit.
Place your larger query in the sub-select area
a few thousand dates for several years into
the future.
You should then be able to do just about any join you need.
M!ke
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 08, 2007 9:10 AM
To: CF-Talk
Subject: RE: Table Data
Thanks
(year, dateTime),
DATEPART(hour, MacLog.DateTime),
Hour.HourOfDay
Thanks pal,
Rob
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: 04 May 2007 16:06
To: CF-Talk
Subject: RE: Table Data
Create a very simple table called Hours
- Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 07, 2007 6:52 AM
To: CF-Talk
Subject: RE: Table Data
Afternoon Mike,
Thanks for this info mate, sorry it's taken me a while to get back, I've
been busy on other stuff. I've set down this morning and played around
with this but I'm
as if it didn't have
the LEFT JOIN attached.
Thanks for any further ideas,
Rob
-Original Message-
From: Dawson, Michael [mailto:[EMAIL PROTECTED]
Sent: 07 May 2007 14:27
To: CF-Talk
Subject: RE: Table Data
If you are getting 0 records, then take it down to a basic query of your
first five
), then LEFT
OUTER JOIN that view to the Hours table.
M!ke
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Monday, May 07, 2007 8:46 AM
To: CF-Talk
Subject: RE: Table Data
Thanks Michael,
After playing around with this a lot today, it seems to defiantly
Morning Guys,
I'm a little stumped on how to resolve this problem, hopefully someone will
have a bright idea on how to achieve it. I have a bunch of table data which
gets displayed hour on hour for a certain time period. This works absolutely
perfectly at the moment, however the little
a few hours if you have a hole in
the data..
On 5/4/07, Robert Rawlins - Think Blue
[EMAIL PROTECTED] wrote:
Morning Guys,
I'm a little stumped on how to resolve this problem, hopefully someone will
have a bright idea on how to achieve it. I have a bunch of table data which
gets displayed hour
rows remain. The
formula would be 24 - query.recordCount. Then, a simple CFLOOP to
display the remaining, empty rows.
M!ke
-Original Message-
From: Robert Rawlins - Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 2:33 AM
To: CF-Talk
Subject: Table Data
Morning Guys
: RE: Table Data
Two solutions:
1. This is another great use of a specialized database table that
contains the hours of the day. Then, you can OUTER JOIN the tables
together which will retrieve all hours, and only the matching records of
the article table.
2. Output your query, then calculate how
, May 04, 2007 9:28 AM
To: CF-Talk
Subject: RE: Table Data
Thanks Michael,
That first solution sounds like a nice idea, would you be able to
elaborate a little more? I'd much rather have my SQLServer do the work
for me.
Thanks,
Rob
- Think Blue
[mailto:[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 2:33 AM
To: CF-Talk
Subject: Table Data
Morning Guys,
I'm a little stumped on how to resolve this problem, hopefully someone
will
have a bright idea on how to achieve it. I have a bunch of table data
which
gets
Hello Guys,
I'm looking for a few ideas from you on the best way to handle statistical
data. I have allot of statistical information on my current application and
when presented I perform general mathematical equations on it, such as
calculating totals, averages, rations and percentages.
I'm looking for a safe way to share the ability to view what data are in
certains tables and to view some stored procedures without giving them access
or exporting the database tables. What' the best way to do this?
~|
Deploy
Assuming that you're using MSSQL or something similar, you can write a
query that hits the metadata.
I blogged on this a long time back at
http://www.ithinkitsnifty.com/index.cfm?commentID=12
HTH
Hatton
On 4/6/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I'm looking for a safe way to share
I am working on a coldfusion page in which I am displaying the Query result on
the screen in a table.But before displaying the data in the cells I am
performing some checks on it.So by the time the browser displays the 100
records on the screen it eats up lot of time.
I tried creating table for
I tried creating table for each row so that the data is displayed as
it fetches it but here the problem is aligning successive tables.
You could declare fixed width for each cell.
--
___
REUSE CODE! Use custom tags;
See
Hussain,
The problem is IE won't display a table until all content is in. FF will load
the table as the data arrives.
To get past this problem try putting this at the top of the page in question:
cfflush interval=1000 !--- number of bytes ---
Michael
From the docs:
Usage
The first
Using cfflush still does not solve the issue. IE will not render the table
till it has the whole table. I have gotten around this problem before by
breaking up a large table into multiple smaller tables. You will have to set
the width of all columns so everything lines up but it should work.
I have tried setting fixed width for each column but the issue is since the
length of the data in it varies the width is also varying according to it.
So irrespective of the width of the cell, the table is adjusting the width to
fit in the data becoz of which the tables are not aligning
I am using the following to get the tablename, column, datatype and length from my SQL Server DB. I only want tables. I am having a brain fart to criteria only tables. Here is my SQL
SELECT
sysobjects.Name as Tablename,
Syscolumns.Name as Fieldname,
Systypes.Name as FieldDataType,
use information_schema - it's a LOT easier
select table_name
from information_schema.tables
Simple, isn't it? g
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 5:13 PM
To: CF-Talk
Subject: QUERY TABLE DATA INFORMATION
I am using
sp_tables
Returns tables with a qualifier for user and system... use q of a q to get at the user tables.
-Mark
-Original Message-
From: Eric Creese [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 11, 2003 4:13 PM
To: CF-Talk
Subject: QUERY TABLE DATA INFORMATION
I am using
Wish this could be done with MS Access :-(
-Gel
-Original Message-
From: Philip Arnold [mailto:[EMAIL PROTECTED]
use information_schema - it's a LOT easier
select table_name
from information_schema.tables
Simple, isn't it? g
[Todays Threads]
[This Message]
[Subscription]
How can I print out all table data - fieldname/datatypes of a specific
database in MS SQL 2000?
Is there a stored procedure I should use?
Thank You,
Dave Bosky
~Sr. Multimedia Web Designer
~HTC Web Services
~[EMAIL PROTECTED]
~office: 843.369.8613
HTC Disclaimer: The information contained
in query analyzer use sp_help tablename (without the quotes).
hth.
mike
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 8:52 AM
To: CF-Talk
Subject: MS SQL 2000 :: How to print table data
How can I print out all table data - fieldname
. I also like grouping tables this way- I can often get several
related tables on one page.
Hope this helps.
J
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 8:52 AM
To: CF-Talk
Subject: MS SQL 2000 :: How to print table data
How can I
I use the query2excel tag and a custom script to allow a user to export
data from a table and download a file. Problem is, if there is a lot of
data in the file, this can take a long time and is a bit error prone. Does
anybody know of a better way to export data?
Is it possible to trigger a
: Dynamically sortable table data
Does anyone know of a way to make database output in a html table
sortable
by any chosen column after the data is output to the table. I am
trying to
avoid CFGRID because of the numerous JVM issues with CF5.0.
Mike Brunt
Sempra Energy
213.244.5226
Smith
-
From: Brunt, Michael [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 3:39 PM
To: CF-Talk
Subject: Dynamically sortable table data
Does anyone know of a way to make database output in a html table
sortable
by any chosen column after the data is output to the table. I am
trying
Does anyone know of a way to make database output in a html table sortable
by any chosen column after the data is output to the table. I am trying to
avoid CFGRID because of the numerous JVM issues with CF5.0.
Mike Brunt
Sempra Energy
213.244.5226
Smith Wesson - the original point and click
Something like IE's data binding?
http://www.webreference.com/dhtml/column39/
Pete
- Original Message -
From: Brunt, Michael [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 11, 2002 3:39 PM
Subject: Dynamically sortable table data
Does anyone know of a way
Only two ways I can think of is either dumping the contents
into Javascript and calling a function to redisplay the contents
or
refreshing the page using using a dynamic variable for sorting.
-- Original Message --
from: Brunt, Michael [EMAIL PROTECTED]
[EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 11, 2002 3:39 PM
Subject: Dynamically sortable table data
Does anyone know of a way to make database output in a html table sorta
ble
by any chosen column after the data is output to the table. I am tryin
g
to
avoid CFGRID
. I love his coding style.
http://www.mattkruse.com/javascript/sorttable/
jon
- Original Message -
From: Brunt, Michael [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, January 11, 2002 3:39 PM
Subject: Dynamically sortable table data
Does anyone know of a way to make
Does it output in order when you just view the cf page? Could it be
something to do with the link into excel. Perhaps it has trouble with some
data types.
-Original Message-
From: Winston Sia [mailto:[EMAIL PROTECTED]]
Sent: 02 March 2001 07:33
To: CF-Talk
Subject: cfquery table data
This is a multi-part message in MIME format.
--=_NextPart_000_01A1_01C0A32E.21E43180
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
=20
Hi,
Thanks for the info, but I'm afraid it isn't returning columns in =
order... especially for tables
46 matches
Mail list logo