Electronics & Programming

develissimo

Open Source electronics development and programming

  • You are not logged in.
  • Root
  • » Django
  • » ANN: dse 0.3.0 DSE - Delayed SQL Executor [RSS Feed]

#1 Jan. 6, 2011 14:49:17

Thomas W.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

ANN: dse 0.3.0 DSE - Delayed SQL Executor


Just released a new version of DSE for django and would like to get
comments, flames, whatever.http://pypi.python.org/pypi/dse/0.3.0--
Mvh/Best regards,
Thomas Weholthttp://www.weholt.org--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

#2 Jan. 7, 2011 08:40:48

bruno d.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

ANN: dse 0.3.0 DSE - Delayed SQL Executor


On 6 jan, 15:49, Thomas Weholt <thomas.weh...@gmail.com> wrote:
> Just released a new version of DSE for django and would like to get
> comments, flames, whatever.
>
>http://pypi.python.org/pypi/dse/0.3.0>

Ok, just browsed the project page, but there's already something that
bugs me : mixedCaps method names instead of PEP08 compliant all_lower.

--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

#3 Jan. 7, 2011 08:46:05

Cal L.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

ANN: dse 0.3.0 DSE - Delayed SQL Executor


Do you have any performance comparisons? Would be interested to see them.

Cheers

Cal

On Fri, Jan 7, 2011 at 8:40 AM, bruno desthuilliers <
bruno.desthuilli...@gmail.com> wrote:

>
>
> On 6 jan, 15:49, Thomas Weholt <thomas.weh...@gmail.com> wrote:
> > Just released a new version of DSE for django and would like to get
> > comments, flames, whatever.
> >
> >http://pypi.python.org/pypi/dse/0.3.0> >
>
> Ok, just browsed the project page, but there's already something that
> bugs me : mixedCaps method names instead of PEP08 compliant all_lower.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to django-us...@googlegroups.com.
> To unsubscribe from this group, send email to
> django-users+unsubscr...@googlegroups.com<django-users%2bunsubscr...@googlegroups.com>
> .
> For more options, visit this group at
>http://groups.google.com/group/django-users?hl=en.
>
>

--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

#4 Jan. 7, 2011 09:00:09

Thomas W.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

ANN: dse 0.3.0 DSE - Delayed SQL Executor


On Fri, Jan 7, 2011 at 9:40 AM, bruno desthuilliers
<bruno.desthuilli...@gmail.com> wrote:
>
>
> On 6 jan, 15:49, Thomas Weholt <thomas.weh...@gmail.com> wrote:
>> Just released a new version of DSE for django and would like to get
>> comments, flames, whatever.
>>
>>http://pypi.python.org/pypi/dse/0.3.0>>
>
> Ok, just browsed the project page, but there's already something that
> bugs me : mixedCaps method names instead of PEP08 compliant all_lower.

Yes, I agree completly - use of mixedCaps or all_lower should at least
be consistent throughout the code. So the code is still messy, but
what about the concept?

--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

#5 Jan. 7, 2011 09:19:38

Thomas W.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

ANN: dse 0.3.0 DSE - Delayed SQL Executor


On Fri, Jan 7, 2011 at 9:45 AM, Cal Leeming
<cal.leem...@simplicitymedialtd.co.uk> wrote:
> Do you have any performance comparisons? Would be interested to see them.
> Cheers
> Cal

These tests were all done using an in-memory SQLite database:

Lots of inserts using dse:

dex = dse.ModelDelayedExecutor(foo)
for i in range(0, 5000):
dex.addItem({'name': 'Person%s' % i, 'age': i})
dex.close()

Takes about 0.107000112534 seconds.

Same thing, using the orm:

for i in range(0, 5000):
foo(name = 'Person%s' % i, age = i).save()

Takes 0.990000009537 seconds. Not that big difference.

But if you want to update a bunch of records, for instance to change a
calculated value ( I`m not doing that here, just changing the name ):

dex = dse.ModelDelayedExecutor(foo)
try:
for item in dex.getItems():
item = "%s Doe" % item
dex.addItem(item)
finally:
dex.close()

It takes 0.12299990654 seconds. Using orm:

for item in foo.objects.all():
item.name = "%s Doe" % item.name
item.save()

it takes 9.60100007057 seconds. It shows that the overhead of using
the orm is significant ( we all knew that allready ).

Regards,
Thomas

--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

#6 Jan. 7, 2011 10:24:20

bruno d.
Registered: 2009-11-02
Reputation: +  0  -
Profile   Send e-mail  

ANN: dse 0.3.0 DSE - Delayed SQL Executor


On 7 jan, 10:00, Thomas Weholt <thomas.weh...@gmail.com> wrote:
> On Fri, Jan 7, 2011 at 9:40 AM, bruno desthuilliers
>
> <bruno.desthuilli...@gmail.com> wrote:
>
> > On 6 jan, 15:49, Thomas Weholt <thomas.weh...@gmail.com> wrote:
> >> Just released a new version of DSE for django and would like to get
> >> comments, flames, whatever.
>
> >>http://pypi.python.org/pypi/dse/0.3.0>
> > Ok, just browsed the project page, but there's already something that
> > bugs me : mixedCaps method names instead of PEP08 compliant all_lower.
>
> Yes, I agree completly - use of mixedCaps or all_lower should at least
> be consistent throughout the code. So the code is still messy, but
> what about the concept?

Deathmarch here so I can't dig further but it might be of interest.
I'll try to spend a bit more time on it ASAP.

--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group athttp://groups.google.com/group/django-users?hl=en.

Offline

  • Root
  • » Django
  • » ANN: dse 0.3.0 DSE - Delayed SQL Executor [RSS Feed]

Board footer

Moderator control

Enjoy the 23rd of October
PoweredBy

The Forums are managed by develissimo stuff members, if you find any issues or misplaced content please help us to fix it. Thank you! Tell us via Contact Options
Leave a Message
Welcome to Develissimo Live Support