ids = tuple(m['id'] for m in relevant_models)
raw_q = db.executesql("""
SELECT
*
FROM "table"
WHERE ("table".ref_id" IN {});
""".format(str(ids)), as_dict=True)
#################### 1.8s
ids = tuple(m['id'] for m in relevant_models)
dal_q = db(
db.table.ref_id.belongs(ids)
).select(db.table.ALL).as_list()
##################### 0.09s
*Web2Py 2.22.3*
Why would the dal query be so much slower than the raw sql? The generated
sql (db._lastsql) is the same as the raw.
--
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 web2py+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/f8add820-3bc0-4220-af0e-ea58e7a18c64n%40googlegroups.com.
