Anyone have syntax to optimize speed of count, to check record existance?
Often just want to check for the existence of ANY records and don't need a
full count, but I only know how to get info from full count. See below
where logic only cares if count is greater than zero.
checking_for_already_existing_connection_count =
db((db.VerifiedConnection.personID == personID.id) &
(db.VerifiedConnection.connectedTo == auth.user_id)).count()
if checking_for_already_existing_connection_count > 0:
redirect(URL('error_duplicate_role'))
Do you have phrasing that perhaps includes ".select(limitby=(0,1)).first()"?
thanks,
Alex Glaros
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
