I was meaning use the SQL server activity monitor to find out exactly what query is being run and how long it is taking. But if you are using SQL server express you won't have that. You can use something like express profile 2.0 which is free though. Being able to see exactly what query is hitting the server can help; I know I have had instances where what I thought was being sent wasn't correct because of an unaccounted for type difference.
You said your table has 100K rows but how many rows are you expecting in the results? -- 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. For more options, visit https://groups.google.com/groups/opt_out.
