List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:January 11 2000 2:38pm
Subject:Re: PASSWORD() vs ENCRYPT() ?
View as plain text  
At 11:57 PM -0800 01-10-2000, dissonant wrote:
>On Tue, 11 Jan 2000, Jason Saunders wrote:
>
>>  [...]
>>  I'm using the C API, so I could just as easily use the encrypt system
>>  call, rather than use the SQL function which calls the same system call.
>>  The question is whether the function is executed in the client or on the
>>  server, which would make a difference over an insecure link.
>>
>>  It would be nice if the PASSWORD() SQL function was faster than the
>>  encrypt system call.
>>
>>  [...]
>
>Lest this thread die prematurely, I'm also deathly curious as to whether
>the ENCRYPT() SQL function is faster than the system call...since, right
>now I'm using the crypt() system call as well, and for those inclined to
>give irrelevant but info-stuffed answers, what I'm doing isn't important
>enough to me to bother using MD5. Thanks,

According to the manual, ENCRYPT() is implemented using the crypt()
system call, so it's doubtful that there is much performance difference.

-- 
Paul DuBois, paul@stripped
Thread
PASSWORD() vs ENCRYPT() ?Jason Saunders11 Jan
  • RE: PASSWORD() vs ENCRYPT() ?John Zook11 Jan
Re: PASSWORD() vs ENCRYPT() ?Jason Saunders11 Jan
  • Re: PASSWORD() vs ENCRYPT() ?Ed Carp11 Jan
  • Re: PASSWORD() vs ENCRYPT() ?dissonant11 Jan
    • Re: PASSWORD() vs ENCRYPT() ?Paul DuBois11 Jan
  • Re: PASSWORD() vs ENCRYPT() ?Sasha Pachev11 Jan
  • Re: PASSWORD() vs ENCRYPT() ?Sasha Pachev12 Jan