Alex Menendez wrote:
>
> hello, all
>
> Given the following situation what is more efficient:
>
> -I have 10 id numbers I want to query on numbers 1,2,3,4,5,6,7,8,9,10
> respectively. However, this list is not fixed and could be any number of
> ids up to 20.
>
> -Is it faster to create a global variable with a prepared sql statement
> at the begining of the mod_perl script as follows:
> $sth = $dbh->prepare('SELECT name FROM table_name WHERE id = ?');
> then iterate through n number of ids later in the script for the
> $sth->execute(1);
>
> -Or is it faster to prepare the statement each time the script is
> called with the following sql statement and execute once:
> $sth = $dbh->prepare('SELECT name FROM table_name WHERE id IN
> (1,2,3,4,5,6....)';
> $sth->execute;
>
> Basically, A persistent sql handle with many executes VS a
> non-persistent sql handle with one execute.
> The dbh is cached and global for both...
Can't you even make a passing attempt to relate this to mod_perl in some
way?
-jwb
