You do not explain why you would need to delete and then insert 25K records to prepare a timetable. It seems that you are creating a temporary table and that is seldom the correct approach.
- If all the data is already available in the tables, then you should be able to write SQL which only selects the rows you require. Iterate those rows to produce your timetable. - If the select is taking too long, then try using pure SQL using db.executesql(). Compare the times. Experiment and optimise the SQL. - If the select is still very slow even using pure SQL, optimise your table schema and use indexes. - Avoid creating temporary tables! -- 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/3fb7e1f3-bda8-4ddf-af94-d0ef0d2c7cc7%40googlegroups.com.
