MS SQL

is there a way to make an image data type as index?

Please support our MS SQL advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Jul 2009

Posts: 5

Reputation: brenn13 is an unknown quantity at this point

Solved Threads: 0

brenn13

Offline

Newbie Poster

is there a way to make an image data type as index?

32 Days Ago

or even make the searching faster when retreiving data. please kindly help me. thnx.

•

Join Date: Feb 2009

Posts: 3,301

Reputation: sknake has much to be proud of

Solved Threads: 588

sknake

Offline

.NET Enthusiast

32 Days Ago

You don't search on the image do you? Are you trying to detect duplicate images or recognize if you have an image already stored in the database? What you should do is store a checksum (md5, crc) in the database in the same row as the image and search on the checksum.

Scott Knake
Custom Software Development
Apex Software, Inc.

•

Join Date: Jul 2009

Posts: 5

Reputation: brenn13 is an unknown quantity at this point

Solved Threads: 0

brenn13

Offline

Newbie Poster

32 Days Ago

•

Originally Posted by sknake

You don't search on the image do you? Are you trying to detect duplicate images or recognize if you have an image already stored in the database? What you should do is store a checksum (md5, crc) in the database in the same row as the image and search on the checksum.

thnx. i'll try it right away.

btw, here is the scene:

i have developed a time monitoring system in vb.net. i can retrieve and save fingerprints in the database. there is no problem, except for one thing.
what if there's a lot of registered fingerprints on the database? what i have done is when the person places his finger on finger scanner, it will search on the similar fingerprint on the database. if there will be 10000 registered fingerprints, i believe it will be very slow to check if the fingerprint is existing or not.

thnx again. i hope u can help me again. but i will try to figure out that checksum thing.

Last edited by brenn13; 32 Days Ago at 5:47 am.