integer sequence randomization

Hi,

I am facing the following problem: I have a database filled with
thousands of records (tickets) distinguished by ther ID. I need to
find a way to generate unique but random integers, preferably based on
IDs of the records and these will work as barcodes (they have to be
"random" so that anyone having one ticket could not guess what is the
other barcode). We've tried generating random numbers and then
checking them against the ones we already have in our database, but
this (obviously) is getting slower and slower as the database is
getting bigger.

I've tried to investigate some possibilities of "randomizing" IDs
according to given rules (1 becomes 3,...), but the resulting sequence
is not "random" enough. Can anyone point me to a possible solution?

Thanks very much, Tom.
.

Relevant Pages

  • Re: integer sequence randomization
    ... I am facing the following problem: I have a database filled with ... thousands of records (tickets) distinguished by ther ID. ... IDs of the records and these will work as barcodes (they have to be ... this is getting slower and slower as the database is ...
    (sci.crypt)
  • Re: PIN System
    ... > digits mean 1:1000000 chance of being robbed). ... you need an online connection to the database ... > from the points where the tickets are to be used. ...
    (sci.crypt)
  • Re: C# + Access Database Problem
    ... The database worked fine in saving and displaying records until it ... retrieves the data from the database on the server and shows the last ... For example the tickets show like this: ... query string. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: integer sequence randomization
    ... I am facing the following problem: I have a database filled with ... thousands of records (tickets) distinguished by ther ID. ... a fairly common method used for user authentication when people sign ... website says go to this page to validate you signed up for an account ...
    (sci.crypt)
  • Re: integer sequence randomization
    ... thousands of records (tickets) distinguished by ther ID. ... this is getting slower and slower as the database is ... You do not say anything about the length, but simply encrypting the IDs ...
    (sci.crypt)
Loading