search huge database quickly

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

Beceriler: Visual Basic

Daha fazlasını görün: what is search string, what is a search string, up string, the string problem, string search in c, string problem, search string in c, search string c, search string, search for solution, search c string, new first search, first search, c string search, c search string, search faster huge database, visual search, spreads, Quickly, fix database, string find, database example, string search, numbers database, visual basic problem

İşveren Hakkında:
( 57 değerlendirme ) Arlington, United States

Proje NO: #749597

13 freelancer bu iş için ortalamada 54$ teklif veriyor


Greetings Texas from Pennsylvania.. {smile} 20+ year VB expert here. Please see PMB for more. Respectfully, Bill.

in 2 gün içinde99.95$ USD
(19 Değerlendirme)

I can help you,have a glance at my feed backs,please.

in 2 gün içinde50$ USD
(35 Değerlendirme)

I can help you.

1 gün içinde 100$ USD
(6 Değerlendirme)

Please Check PM

in 2 gün içinde30$ USD
(4 Değerlendirme)

Please see private message. Thanks, John

1 gün içinde 50$ USD
(1 Değerlendirme)

I have more then 8 years experience on sql server. please pm me.

in 5 gün içinde30$ USD
(3 Değerlendirme)

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.

in 2 gün içinde60$ USD
(1 Değerlendirme)

I did almost exactly the same case as yours last week..

in 5 gün içinde40$ USD
(0 Değerlendirme)

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

1 gün içinde 85$ USD
(0 Değerlendirme)

Hello, check PM please, thanks

1 gün içinde 30$ USD
(0 Değerlendirme)

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 to Daha fazlası

in 3 gün içinde50$ USD
(0 Değerlendirme)

I have 14 years VB enterprise-level experience.

1 gün içinde 30$ USD
(0 Değerlendirme)

i can help you!

in 2 gün içinde50$ USD
(0 Değerlendirme)