Kapalı

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: up string, string problem, new first search, first search, search string, search faster huge database, visual search, spreads, quickly, fix database, string find, database example, string search, numbers database, visual basic problem, program basic string, quickly hours, search solution, running faster, find fix program, database fix, example visual basic, database created, userid, search location

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

Proje NO: #749597

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

wsh2

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)
5.2
northwolves

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

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

I can help you.

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

Please Check PM

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

Please see private message. Thanks, John

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

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

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

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)
2.2
jokgarcia79

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

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

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)
0.0
self

Hello, check PM please, thanks

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

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)
0.0
Beaker1969

I have 14 years VB enterprise-level experience.

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

i can help you!

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