Gossamer Forum: Products: Gossamer Links: Discussions: Re: [el noe] performance difference do

Gossamer Threads

Home : Products : Gossamer Links : Discussions :

Products: Gossamer Links: Discussions: Re: [el noe] performance difference do_query prepare + execute: Edit Log

Here is the list of edits for this post

May 6, 2021, 8:03 AM

Andy

Veteran / Moderator (18441 posts)

May 6, 2021, 8:03 AM

Re: [el noe] performance difference do_query prepare + execute

Hi,

Are you asking if your 1st or 2nd query is faster?

BTW I would personally do:

Code:
sub {  
	my $Links = $DB->table('Links'); 
	   $Links->select_options("LIMIT 0,1"); 
    return $Links->select( ['Contact_Email'], { BrandID => $_[0] } )->fetchrow || undef 
}

That gets around placeholders, and any potential SQL injection issues as well then

Cheers

Andy (mod)
andy@ultranerds.co.uk

Last edited by:

Andy: May 6, 2021, 8:06 AM

Edit Log:

Post edited by Andy Post edited by Andy (Veteran) on May 6, 2021, 8:05 AM
Post edited by Andy Post edited by Andy (Veteran) on May 6, 2021, 8:06 AM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676