treemenus treemenu or sitetree

Hi List I'm currently using django-treemenus to show a site menu, but now that Im migrating to 1.8, Im getting imcompatibility bugs. What modules do you use to display link menus in your site? I found sitetree and treemenu but they are not mentioned at all on this forum. thanks! -- You recei

oracle syncdb crashes while setting column to NULL when it already is NULL

hi I'm not sure if this is a dev question or it should be posted here. Probably I did something dumb, so I hope you can help me doscover what that is: I'm trying to syncdb to an empty Oracle DB. Many tables, triggers and sequences are made but then this: -- ...

Re: django select extremely slow on large table

That sounds only relevant if Django creates the tables tight? You cannot do that with partitioned Oracle of this size. As much as I like to have django create the schemas, legacy db is all I have. THe entire DB is over 2TB of data, you cannot just change a column field type or add an index witho

Re: django select extremely slow on large table

And to keep replying to myself: This one is slow: x=Marker.objects.raw("SELECT * from PROD_SCHEMA.MARKER WHERE MARKID= %s",[u'TO1']) print x[0] This one is fast: y=Marker.objects.raw("SELECT * from PROD_SCHEMA.MARKER WHERE MARKID= 'TO1'") print y[0] If I copy the table and make the MARKID fiel

Re: django select extremely slow on large table

Skip that, >>>x=Marker.objects.raw("SELECT * from VARIANT_CLONE.MARKER WHERE MARKID='TO1'") is fast DEBUG (0.001) QUERY = u"SELECT * from SCHEMA_PROD.MARKER WHERE MARKID='mTO1'" - PARAMS = (); args=() -- You received this message because you are subscribed to the Google Groups "Django use

Re: django select extremely slow on large table

As an addition: >>>x=Marker.objects.raw("SELECT * from VARIANT_CLONE.MARKER WHERE MARKID='TO1'") This is also slow so it indeed seems to be a locale issue the database is AL32UTF8 and django uses national character set id "2000" is this a locale issue? -- You received this message because yo

Re: django select extremely slow on large table

This seems to be specific for partial text searches (LIKE, STARTSWITH etc). Still, interesting addition. -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-

Re: django select extremely slow on large table

Very interesting point. In the backend the MARKID column is of type VARCHAR2(20 BYTE). This is not something I can change. But it does seem that the bindvar method forces a unicode lookup onto an ascii table. Is there any way to make django get this field in ascii to test this theory? -- You

Re: django select extremely slow on large table

THank you all for your help there's a few things here: * This Oracle table is highly partitioned and optimized.There's indexes everywhere. There's two full time senior Oracle DBAs working on tuning this DB.So a return of 0.1 sec is not strange for this setup. (btw the DBAs are really impressed

Re: django select extremely slow on large table

d SYS_GUID." > } > > description = "A connector to the SYS_GUID() fields for Oracle > Backends" > > def __init__(self, *args, **kwargs): > kwargs['max_length'] = 16 > super(SYSGUID16Field, self).__init__(*args,**kwargs) > >

django select extremely slow on large table

Dear List, I'm trying to run a simple select on a very large Oracle table (1500 million records). I create a standard django model: -- class Marker(models.Model): marker_id = SYSGUID16Field(primary_key=True) # This field type is a guess. markid = models.CharField(uniqu

Re: Django vs ExtJS

he migrations as well. >> >> I've done basically the same thing with Django REST Framework and AngularJS >> for the frontend. Works like a charm, and with the business logic on the >> signals, reduces the dev time by 90%. And worls like a charm. >> >> Em Tue De

Re: Django vs ExtJS

en standard). If you provide more specific info about the project, maybe we can come with some more concrete comparsions. Em Mon Dec 29 2014 at 12:56:05, Joris Benschop mailto:joris.bensc...@gmail.com>> escreveu: Hi List, I;m a data maangement specialist in a rather large multinat

Django vs ExtJS

Hi List, I;m a data maangement specialist in a rather large multinational. I'm trying to push Django as a fast development framework for front-end applications of our databases. Currently the company is focusing on Sencha ExtJS and java solutions. Can you help me with pointers why Django is be

Re: UUID as primary key for Oracle backend

replying to myself: setting the pk to a binaryfield breaks the usage of django-admin as this tries to force the pk into string as well (options.py function action_checkbox()). -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from

UUID as primary key for Oracle backend

Hi list I'm trying to use Django 1.7.2 with an Oracle 11.2 backend. THis backend uses RAW(16) fields as primary keys everywhere (it wasnt my choice). THis is however giving me major headaches, as Django seems to insist on decoding these keys to text. Here''s my models: #models.py from django.db

Re: merge data from multiple models

Op maandag 30 juli 2012 16:06:38 UTC+2 schreef Joris het volgende: > > > > On Monday, July 30, 2012 3:52:31 PM UTC+2, Melvyn Sopacua wrote: >> >> >> If this is not implemented as a OneToOneField, then do so. You can then >> access the related object in the same way as the reverse of a ForeignKey