Think of it as any normal database application. As far as Web2py doesn't create indexes, you must take care of it by yourself.
If your IS_IN_DB() validator refers to a field that isn't indexed, your performance will suffer. -- Vinicius Assef. On Fri, Nov 4, 2011 at 1:33 AM, Pystar <aitoehi...@gmail.com> wrote: > Another Question: > what is the performance drawback in using IS_IN_DB() validator in a > form? From what I understand, web2py checks if the query passes > against the database before doing a database insert or any other > action. I would like to know if there would be a performance degrade > as the number of records in the database increases and that means the > more records the IS_IN_DB() validator has to check itself against? > Thanks > > On Nov 4, 4:13 am, Pystar <aitoehi...@gmail.com> wrote: >> Thanks Max >> >> On Nov 4, 4:07 am, Massimo Di Pierro <massimo.dipie...@gmail.com> >> wrote: >> >> >> >> >> >> >> >> > I always use request.now.I think of utfnow as a utility in case there >> > ar multiple servers in different dimezones. >> >> > On Nov 3, 9:46 pm, Pystar <aitoehi...@gmail.com> wrote: >> >> > > I have another question, >> > > Whats the best way to get the time to use for a time stamp field in a >> > > database insert? request.utcnow? I would like to do time comparisons >> > > between when a record was inserted into a database and the present >> > > time, so would request.utcnow suffice? and if it would, how do I get >> > > the time elapsed value? between the 2 values? >> > > thanks >> >> > > On Nov 4, 3:41 am, Pystar <aitoehi...@gmail.com> wrote: >> >> > > > I would like some clarification on the Decimal type field in DAL. From >> > > > the book, in the complete signature for Decimal type is "decimal(n,m)" >> > > > where; >> > > > n -- total number of digits >> > > > m -- total number of digits after the decimal point >> > > > if I am to specify a decimal type field that has 4 digits after the >> > > > decimal place how would I specify that? since I cant really determine >> > > > before hand how many digits in total the decimal number would contain. >> >> > > > Would specifying the field as "decimal(, 4)" work i.e. leave out the >> > > > "n" value ? or is there something I am not getting? >> >> > > > Thanks for your swift response. >> > > > Pystar