He's using update_or_insert, not validate_and_update, so no validation involved.
Anthony On Wednesday, May 2, 2012 5:43:43 PM UTC-4, rochacbruno wrote: > > obviously it will take more time, and the time depend on the validators > you are using and the total of fields you are updating. > > Do you have custom validators? (share the code) > Of the built in validators, which you are using? how? > > Validating is a pre-processing and of course it will take some more time. > > On Wed, May 2, 2012 at 6:19 PM, puercoespin < > jzaragoza.puercoes...@gmail.com> wrote: > >> In my app, .update_or_insert takes more time that code by hand. >> >> In a database with 5 tables and 60.000 records in total, the execution >> time was: >> >> without .update_or_insert: 0 minutes. 48 secons (Code) >> >> >> if combustible == G95: >> >> row=db(db.G95.LongitudLatitud==LongitudLatitud).select().first() >> if row: >> >> row.update_record(Precio=float(Precio),Fecha_Actualizacion=Fecha_Actualizacion) >> else: >> >> db.G95.insert(Latitud=float(Latitud),Longitud=float(Longitud),Gasolinera=Gasolinera,Precio=float(Precio),Fecha_Actualizacion=Fecha_Actualizacion) >> >> with .update_or_insert: 1 minute, 53 secons. >> >> (Code) >> >> >> if combustible == G95: >> >> db.G95.update_or_insert(db.G95.LongitudLatitud==LongitudLatitud, >> LongitudLatitud=LongitudLatitud,Latitud=float(Latitud),Longitud=float(Longitud),Gasolinera=Gasolinera,Precio=float(Precio),Fecha_Actualizacion=Fecha_Actualizacion) >> >> >> What's your opinion? >> > > > > -- > > Bruno Rocha > [http://rochacbruno.com.br] > >
