what is your database engine?
we need to see if the bottleneck is in database side.
Place a {{=response.toolbar()}} in your view and paste here the generated
SQL and timings.
Are you using pagination? how many per page? even with 100.000 records, the
grid should use an offset to limit the loaded data.
On Fri, Feb 22, 2013 at 2:56 AM, newbie <nehadu...@gmail.com> wrote:
> Hi ,
> i am a newbie in Web2py....I have more than 1 lakh records in database
> table1 and i am displaying that table through an SQLFORM.grid.The problem
> is the corresponding WebPage for this table1 is taking more than 15 seconds
> to open.Is there a way we can solve this performance issue??.....Kindly
> help......
>
> Default.py
>
> def WebPage():
> grid=SQLFORM.grid(db.table1)
> return locals()
>
> WebPage.html
>
> {{=grid}}
>
> and table1 has more than 1 lakh records.
>
> --
>
> ---
> 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.
>
>
>
--
---
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.
