in places where i wanted to keep the dropdown, but not the overhead of
creating a huge list, i filtered the list. I was lucky enough that not all
of the options were valid in all tables, and so i modified my IS_IN_DB()
calls to return a much smaller filtered set of data. not sure if this will
On 28 January 2011 14:09, Alexandre Andrade wrote:
> I think you need manually create index(es) in the database.
>
I did create indexes although I do not think it should be necessary for
id-fields in the light of the following quote from Postgresql documentation:
"PostgreSQL automatically create
I think you need manually create index(es) in the database.
2011/1/28 Johann Spies
> I have a lot of foreign keys in a database of which some tables have more
> than 30 records. What is happening is that if a link to add a record
> is selected it takes a long time before the form appears
ops! sorry my last comment is for another post :( ,
please ignore what I said ...
--
Lucas D'Avila
http://flavors.me/lucasdavila
Em 28/01/2011 09:54, "Johann Spies" escreveu:
On 28 January 2011 13:30, Lucas D'Avila wrote:
> Hi !
>
> You can be more specific? have any suggestions to improve this?
>
OK. For the following model, calling DAL.create it takes 65 seconds to open
the form using web2py's own webserver and 35 seconds when using Apache +
WSGI. Both too long:
Hi !
You can be more specific? have any suggestions to improve this?
--
Lucas D'Avila
http://flavors.me/lucasdavila
Em 28/01/2011 09:19, "Johann Spies" escreveu:
I have a lot of foreign keys in a database of which some tables have more
than 30 records. What is happening is that if a link to add a record
is selected it takes a long time before the form appears because all the
cross referencess in the IS_IN_DB-dropdowns have to be assembled.
How do I s
7 matches
Mail list logo
