Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [Andy] performance difference do_query prepare + execute

Quote Reply
Re: [Andy] performance difference do_query prepare + execute In reply to
Hi Andy,

Thanks for your reply. The question was indeed which way would probably be the fastest.
The request is just an example of many amd which in this case probably could be done nice the LinksSQL way in your example.
Regarding this the question is which of the three ways could be the fastest/best.
As far as I have understood doing the same queries with placholders leads to a one cached query in mysql whereas my example without placholder would be a unique query for every case.
Not sure if I got that right.
If that is correct the question is if the now three examples do have different outcomes in LinksSQL and in the way they are handed over to mySQL.

Regards

n||i||k||o
Subject Author Views Date
Thread performance difference do_query prepare + execute el noe 3374 May 6, 2021, 12:09 AM
Thread Re: [el noe] performance difference do_query prepare + execute
el noe 3313 May 6, 2021, 3:36 AM
Thread Re: [el noe] performance difference do_query prepare + execute
Andy 3315 May 6, 2021, 8:03 AM
Thread Re: [Andy] performance difference do_query prepare + execute
el noe 3302 May 6, 2021, 8:35 AM
Thread Re: [el noe] performance difference do_query prepare + execute
Andy 3298 May 6, 2021, 8:56 AM
Post Re: [Andy] performance difference do_query prepare + execute
el noe 3256 May 11, 2021, 1:17 AM