Re: Query performance plain/text versus AES_DECRYPT(): LIKE %..%

E %..%):1.383749s Decrypt test (AES_DECRYPT() LIKE %..%): 1.441944s done <<<<< Nonetheless, I'd still argue that this entire concept is doomed to terrible performance anyway. Regards, Jeremy John Kraal wrote: I put it here: http://pro.datisstom.nl/tests/bench.ta

Re: Query performance plain/text versus AES_DECRYPT(): LIKE %..%

crypting backups and setting system-level policies. Regards, Jeremy John Kraal wrote: Dear you, I've been working on encrypting some data for a customer. They want their personal/sensitive information encrypted in the database, but they want to be able to search it too, through the applic

Re: Query performance plain/text versus AES_DECRYPT(): LIKE %..%

-Original Message- From: John Kraal [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 23, 2007 8:51 AM To: mysql@lists.mysql.com Subject: Query performance plain/text versus AES_DECRYPT(): LIKE %..% Dear you, I've been working on encrypting some data for a customer. They want their per

Query performance plain/text versus AES_DECRYPT(): LIKE %..%

istent". I've attached all the files I used for this test. Edit db.inc.php (add some more lipsum if you want), execute fill.php, and then have fun with bench.php. Does any of you know why this is, how come, etc? I'm just very curious. Regards, John Kraal -- / Humanique /