Create a database view that UNIONs all the tables. Each year, alter the
view to include the new archived table.
Of course, this doesn't solve the problem that you still have to weed
through 60K rows of data...there is no solution to that problem. You have
60K rows that you have to look at and you will always have 60K rows. You
might buy some speed by writing the SQL better, but your disk access time is
still the slowest part of the equation.
Short answer - you need to throw more/better hardware to get a significant
speed increase.
Brian
-----Original Message-----
From: Lena Trajkovska [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001 4:23 AM
To: CF-Talk
Subject: One Crystal report with variable name of the table
Hi!
Merry Christmas and Happy New Year to you all. For the new year I have a
new problem. The application that we are developing needs to have an
archiving part for the invoices and accounting package. So, we decided to
create archive tables that will be named the same as the current one with
the suffix "_2000". The problem is we have to make reports to view the data
in those tables, and thinking of the future, the name of the table should be
variable - if we want to see the data from year 2000 we will call the report
with the input parameter "_2000" or the whole name of the table. Somehow, I
think that this is not possible with CR 7. Can any one give me an idea for
the solution of my problem? Does anyone have this problem or did have it?
One solution is with creating temporary table which will be filled with the
correct data before issuing the report - but the tables will contain over
60000 records - and the servers are just PII400, NT4 - Oracle 8 - so this
would be very time consuming action as it shouldn't be.
Could you please, share your thoughts with me?
Thank you in advance,
Lena Trajkovska
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
