I need a creative solution to an SQL problem. 
Author Message
 I need a creative solution to an SQL problem.

I have an application on hand that processes
files coming from a telephone exchange.  The
approximate file size is about  500,000 rows.
I load the file into a table, I then generate a
temporary table that sums up the calls per unique
telephone number.  I then have to update the up-to-date
table which indicates how much each telephone number
ows up to this processed file.  I porcess about 15 files
a day.  The update is simple:

        update amount = amount + new_amount.

The challenge is that I cannot chunk the transaction. It
all has to be done as one single transaction.  If I chunk
the logic, one telephone number can be updated twice.
The logic works in such a way that if there is any error,
it rollsback and continues with the next file. It comes
back to the failed file after there are no more files to process.  
I do not want to run into filling up the log file.  This is why I'm
looking for a way to chunk.

I am not using Sybase.  However, I like the talent on this
newsgroup since I've gotten a few good ideas from it in
the past.

Nabil Courdy
Senior DBA



Thu, 09 Dec 1999 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Need help in finding a creative solution.

2. Looking for a creative web security solution

3. Looking for Creative Index Solution

4. Need solution for memory leak problem with dynamic SQL

5. Creative SQL Help

6. Solution on Performance Problems Needed

7. Simple Problem - Need solution

8. Big Problem..Need solution quickly

9. Recordset error problem need solution

10. Solution on Performance Problem Needed.

11. ASP Grid sorting problem - need solution fast Thanks

12. VB, Crystal Reports, Oracle - Need Solution to Business Problem


 
Powered by phpBB® Forum Software