Re: Finding missing numbers in sequence

2004-05-20 Thread John W. Krahn
Larry Wissink wrote: > > We have a backup server that is missing records from the production > server for a particular table. We know that it should have sequential > records and that it is missing some records. We want to get a sense of > the number of records missing. So, we know the problem

Re: Finding missing numbers in sequence

2004-05-13 Thread Jeff 'japhy' Pinyan
On May 12, Larry Wissink said: >We have a backup server that is missing records from the production >server for a particular table. We know that it should have sequential >records and that it is missing some records. We want to get a sense of >the number of records missing. So, we know the prob

Re: Finding missing numbers in sequence

2004-05-13 Thread Chris Charley
- Original Message - From: "Larry Wissink" <[EMAIL PROTECTED]> Newsgroups: perl.beginners To: <[EMAIL PROTECTED]> Sent: Wednesday, May 12, 2004 6:39 PM Subject: Finding missing numbers in sequence I have a problem that I thought would be perfect for Perl, except t

Re: Finding missing numbers in sequence

2004-05-13 Thread Ramprasad A Padmanabhan
I think there will be some optimizations always possible, but You wont get any dramatic improvements. What I would do is something like this First make sure that all the data is sorted in the file Create a sequence array of all the required numbers, In your example it was all numbers from 1..10 #

Finding missing numbers in sequence

2004-05-13 Thread Larry Wissink
I have a problem that I thought would be perfect for Perl, except that I seem to be using all my system resources to run it. Of course this probably means I'm doing it the wrong way... The problem: We have a backup server that is missing records from the production server for a particular tab