List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:November 9 2010 1:35pm
Subject:Re: Best encription method?
View as plain text  
Seems like a better plan than simply rolling your own, yes. Do make sure
that the key string is well-documented :-p

On Tue, Nov 9, 2010 at 2:30 PM, Vikram A <vikkiatbipl@stripped> wrote:

> Sir,
>
> We have done a encryption by using our own algorithm. it works fine. But
> during
> the report analysis we are facing the performance issue. Which is not
> appreciated by our users.
>
>
> We need only one column to be encrypted and the column size will never
> exceed 3
> chars.
>
>
> We have planed to use the AES_ENCRYPT and AES_DECRYPT by using the "key
> string"
> as a parameter. We can keep this key string as our security point. We found
> it
> is giving better performance in all cases.
>
> Can i have  your advise please?
>
> Thank you in advance!
>
> Vikram A
>
>
>
>
> ________________________________
> From: Vikram A <vikkiatbipl@stripped>
> To: Johan De Meersman <vegivamp@stripped>
> Cc: MY SQL Mailing list <mysql@stripped>
> Sent: Wed, 29 September, 2010 11:46:18 AM
> Subject: Re: Best encription method?
>
>
> Sir,
>
> I must adopt the encryption. I shall bear the cost of the memory.
> Thank you for the guidance.
>
> Vikram A
>
>
>
>
> ________________________________
> From: Johan De Meersman <vegivamp@stripped>
> To: Vikram A <vikkiatbipl@stripped>
> Cc: MY SQL Mailing list <mysql@stripped>
> Sent: Tue, 28 September, 2010 2:08:57 PM
> Subject: Re: Best encription method?
>
>
>
>
> On Mon, Sep 27, 2010 at 3:43 PM, Vikram A <vikkiatbipl@stripped> wrote:
>
>
> >Normally, If i need to store an integer value i have to define it as int,
> If I
> >encrypt this, i must define its type as string of different size[it depend
> upon
> >the encryption output] than its original size. It increases the db size. I
> am
> >known that if it is secure i have to choose encryption. but when i choose
> >encryption it leads the more memory usage.
> >
>
> Well, yes :-) That's part of the price you're going to pay for the
> security.
>
> As the programmer said; I can make it better, faster and cheaper. Pick any
> two.
>
>
> --
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>
>


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Thread
Re: Best encription method?Vikram A9 Nov
  • Re: Best encription method?Johan De Meersman9 Nov
    • Re: Best encription method?Vikram A9 Nov