Hi,
I made some tests with lots of data on some tables.
In some tests I was using:
SQLFORM(db.table, record=rc)
But it became very slow after putting data
When I was debugging I found that if you use IS_IN_DB() it searches the
other table even if you are selecting one existing record or inserting a
new one.
This is the line of code that turns SQLFORM slow sqlhtml.py:
elif OptionsWidget.has_options(field):
if not field.requires.multiple:
inp = self.widgets.options.widget(field, default)
else:
inp = self.widgets.multiple.widget(field, default)
The example is:
table a
id
name
table b
id
id_table_a (is_in_db)
if you use SQLFORM(db.table_b, record=x)
and if the table a have 10k records or more
the process runs very slow
debugging I saw that even inserting new record or selecting one record it
checks all over table a...
I know that if you are updating the process depends on your database
speed.. but it should not compromisse on inserting or viewing right?
Is there any solution for this?
Thanks
--
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.
