in reply to Re: search like
in thread search like

it might still query the database for all the rows that meet the where clause ... check the SQL ...

Could also be worth doing an EXPLAIN on the query - if the DB has to do a table scan then the query could still be slow/heavy even if the SQL looks sane.

Replies are listed 'Best First'.
Re^3: search like
by Moron (Curate) on Feb 28, 2007 at 14:51 UTC
    Assuming the DBMS knows "explain", which is why I had to put in the caveat about the DBMS. I myself come from a Sybase background which requires different commands like "set showplan" to do that kind of thing. And what if it's mysql?

    -M

    Free your mind

[reply]

In Section Seekers of Perl Wisdom