I have a program in Visual Basic 6 that i have wrote that connects to a database of over 1.7 million different userids. The userids are all numbers and range from 6 digits to 12 digits. The program collects userids from a location on a site then checks this database to see if the userid is already in the database. If the userid is not in the database it adds it into the database. The problem i have is it takes about 3 seconds to look through the database in order to find out if that userid is already in the database. I need a method of doing this exact thing except it take just millaseconds.
I have come up with a way to do this that takes just millaseconds, but my method must have a flaw because after a few hours of my program running and checking userids it finally crashes. The method i use that takes just millaseconds is where i have created a string like this:
Dim Cache(0 to 999999) as string
I then load all 1.7 million of the userids into one of the possible 999,999 cache spots. For example if one of the userids was 123456789 then that userid would load in Cache(123456). As you can see i just take the first 6 digits. This spreads out the userids and makes it much easier and faster to check if the ids have been saved already. The only problem is now that i have 1.7 million userids saved my program crashes after just a few hours or use. I am not looking for anyone to fix this method. I want someone to either create a new method that can do what have described above in just millaseconds or come up with a database solution i can use that takes just millaseconds to check even with the database being 1.7 million in size. Thanks
My name is Matt Jones and I'm the sole proprietor of JJ Computer Consulting. I am a US based operator that specializes in desktop applications. Please see my PM for more information.
Hi there,
I am a mathematician and programmer with an experience of over 12 years programming and creating algorithms for numnerical algebra.
I am keen to deliver you the solution.
regards
Hi there
I'm a programmer for more than 10 years using vb6, sql, pl-sql, crystal reports, and also more than 2 years using vb.net
I can do this
Count me in
However i need to look first the Database and your code too