"Bob Badour" <bbadour@golden.net> wrote in message <news:rJmdndW9eNtgeEqiRVn-iw@golden.net>...
> "John Isaacks" <jisaacks@yahoo.com> wrote in message
> news:8a9a4c2a.0312101423.4d31c3d4@posting.google.com...
> > I don't know how high your requirement for having an SQL interface is.
> > At my company we wrote a real-time database for the local number
> > portability, with over 40M entries, with support for variable length
> > phone numbers ( up to 10 digits ). The customer wanted the longest
> > phone number match possible. example there could 1, 12, 123 in the
> > database and the number 1234 would match to 123.
> >
> > We did it with C++ and a memory mapped file for persistence.
> > We had to use a 64bit cpu and 12G of RAM.
>
> Wow! That's only 300 bytes of RAM for every 10 digit phone number!
They must have been using Prevayler...
g/d/r
--
Joe Foster <mailto:jlfoster%40znet.com> Sign the Check! <http://www.xenu.net/>
WARNING: I cannot be held responsible for the above They're coming to
because my cats have apparently learned to type. take me away, ha ha!
