MySQL Forums
Forum List  »  Newbie

Re: Fastest way to check for an image in a table
Posted by: Sebastian Jurk
Date: September 26, 2010 10:47AM

Youre right... Looks like the number of hashes wont be a problem very fast...

How about the speed? I mean I dont have very much knowledge in speedthings. I know from experience that a big table can be very fast when adding a index. And I know that stringcomparisions can be very lame. For example there was a table that stored numbers but they were stored as varchar. I changed it to int and the speed was way faster. Thats the reason I think stringoperations are way more slow.

So would it be wise to add the size of the image as int and request this first and after this request the hash? Wouldnt that be faster?

How is the speed of fulltext-selects compared to int-selects? And how about binary?

Options: ReplyQuote


Subject
Written By
Posted
Re: Fastest way to check for an image in a table
September 26, 2010 10:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.