On Fri, Jun 4, 2010 at 01:25, Matthew <matthew.g.nor...@gmail.com> wrote:
> When implementing "LIKE", I noticed that the following line is
> extremely slow (for large numbers of records) on RDBS:
>
> rows = db(buyer.id>0).select().find(lambda
> row:row.name.startswith('C'))

Did you try:
rows = db(db.buyer.name.like('C%')).select()
?

-- 
Álvaro Justen - Turicas
 http://blog.justen.eng.br/
 21 9898-0141

Reply via email to