in reply to DBI:SQLite bind_param problem
Beware the performance implications of using Wildcard characters and the LIKE operator:SELECT * FROM tblBlogPosts WHERE fldTags LIKE '%?%'
Under most circumstances, the original LIKE or GLOB operator is still tested against each input row ..This means your database backend must do a full table scan for every query. As the database grows, the queries will take increasingly long time to complete.
Disclaimer: I've no experience with SQLLite. The above applies to all other database I know of: MySQL, Postgres, Oracle, DB2, SQL Server.
|
|---|