No. Do not much about it.
On Dec 7, 3:45 pm, "G. Clifford Williams" <[email protected]> wrote: > Is VoltDB supported? > > Sent from some mobile device > > On Dec 7, 2010, at 2:09 PM, Bruno Rocha <[email protected]> wrote: > > > MongoHQ can be useful for testing, they offer a free limited instance > > >https://mongohq.com/pricing > > > 2010/12/7 mdipierro <[email protected]> > > I run some benchmarks. The time to do insert and select is the same. > > The difference it no measurable because dominated by db IO. Anyway the > > code is below and the output is: > > > old dal: > > 7.98740386963e-05 (sec) > > 0.00134269499779 > > > new dal: > > 8.04572105408e-05 > > 0.00139242005348 > > > Notice all the time is in the IO. The time to actually parse the > > complex query is negligible. > > > code: > > import os > > os.system('rm *.sqlite test* *.table sql.log') > > > #from dal import > > * > > from sql_old import * > > db=DAL('sqlite://test.sqlite') > > db.define_table('person',Field('name')) > > db(db.person).delete() > > db.commit() > > > import time > > > def t(f,n=1000): > > t0=time.time() > > for i in range(n): f() > > return (time.time()-t0)/n > > > def a(): > > db.person.insert(name='max') > > def b(): > > db((db.person.name=='max')&(db.person.name.like('max > > %'))&(db.person.name.startswith('m'))).select(limitby=(0,20)) > > > print t(a) > > print t(b) > > > -- > > > Bruno Rocha > >http://about.me/rochacbruno/bio > >
