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

Thread Solved

•
•
Join Date: Jul 2009
Posts: 5
Reputation: brenn13 is an unknown quantity at this point 
Solved Threads: 0
brenn13 brenn13 is offline Offline
Newbie Poster

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

 
0
  #1
Nov 9th, 2009
or even make the searching faster when retreiving data. please kindly help me. thnx.
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2009
Posts: 3,444
Reputation: sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of 
Solved Threads: 627
Sponsor
sknake's Avatar
sknake sknake is offline Offline
.NET Enthusiast
 
0
  #2
Nov 9th, 2009
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.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2009
Posts: 5
Reputation: brenn13 is an unknown quantity at this point 
Solved Threads: 0
brenn13 brenn13 is offline Offline
Newbie Poster
 
0
  #3
Nov 9th, 2009
•
•
•
•
Originally Posted by sknake View Post
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; Nov 9th, 2009 at 5:47 am.
Reply With Quote Quick reply to this message  
•
•
Join Date: Jul 2009
Posts: 5
Reputation: brenn13 is an unknown quantity at this point 
Solved Threads: 0
brenn13 brenn13 is offline Offline
Newbie Poster
 
0
  #4
Nov 10th, 2009
its working now. thnx. i have used binary_checksum now its running pretty well in 100 users. gotta fill 900 more to test it's efficiency. thnx again.
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread has been marked solved.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the MS SQL Forum


Views: 537 | Replies: 3
Thread Tools Search this Thread



Tag cloud for MS SQL
"last age autogrowth business connectingtodatabaseinuse count cursor data database dateadd datediff datepart day" dbsize deadlock delete_trigger exploit getdate hack highperformancecomputing hpc hpcserver2008 ibm iis limit live loop maximum microsoft ms mssql multiple multithreading news number password permission position query reporting result security server services sets single source sql sql-injection sqlserver sqlserver2005 subtype supercomputing supertype tables uniqueid update view weekday
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC