very slow work with 400 rows table

[vityah1]

Hello

This is normal when django-unicorn with table on 400 records works very slow?

I wait 10 sec until see any reaction on click

Thanks

[adamghill]

Unicorn is easy to start with, but the trade-off is that sometimes it needs to be tweaked for certain use-cases. For a lot of data, you might need to tweak some things for acceptable performance. Suggestions of where I would look:

• If the click is only updating a portion of the page, partial update might be helpful: https://www.django-unicorn.com/docs/partial-updates/
• Exclude any data from being rendered for JavaScript that isn't absolutely necessary to prevent unnecessary serialization: https://www.django-unicorn.com/docs/advanced/#javascript-exclude

If you can fork the repo and add some code to the example project or have some example code you can put into a public repo, I might be able to give you more specific help to optimize performance (or make updates to Unicorn which would benefit everybody).

[vityah1]

Thanks for answer.

I show some of my code here. if you check my code i will be very grateful for your help

This is template with table with 400-500 rows.
phone.html.zip

This is my code
phone.py.zip

I thinks this is typical CRUDe like code for some dictionaries.

May be you can say me what I need change for work faster?

Thanks.

[vityah1]

So, not any way to speed up work ?
I dont know how I can use partial update if I need reaction on click every of 400 rows.
Do you can advise something me about it?

[adamghill]

Thanks for the code you sent me. The reason I ask for a fork or a repo is so I don't need to integrate your code into my tests manually. For example, I'm also unsure what your Phone model fields are like. I just used this for my testing:

class Phone(models.Model):
    deleted = models.IntegerField(default=0)
    iptel = models.CharField(blank=True, null=True, max_length=1024)
    cdep = models.CharField(blank=True, null=True, max_length=1024)
    c_sti = models.CharField(blank=True, null=True, max_length=1024)
    posada = models.CharField(blank=True, null=True, max_length=1024)
    cpib = models.CharField(blank=True, null=True, max_length=1024)
    kab = models.CharField(blank=True, null=True, max_length=1024)
    tel = models.CharField(blank=True, null=True, max_length=1024)

Here's a GIF of the response time on my local when I click a link in the list of 400.

However, notice the response size of 150 KB-200 KB? If your model has a lot of data in it that size will become very large. That might be one reason the response time is slow. https://www.django-unicorn.com/docs/advanced/#javascript-exclude can be used to prevent parts of the model from being serialized and sent back and forth on every request/response.

Do you run into the same issues when it's only 5 instead of 400 results? Another approach could be to paginate the results.

There might be other solutions as well, but it's challenging to debug without having all the code to replicate the problem. Let me know if you continue running into problems and I'll try to help as best as I can!

[vityah1]

Very thanks for Your answer

I attach video with my work responces
May be this help understant situation

django-unicorn.mp4

I see that very slow work in the backend

[adamghill]

Can you send me the data for that phone record? I'm going to see if serialization is super slow for non-Latin characters or something, but that will be easier if you can give me the data. :)

[vityah1]

Thanks for answer
Yes, of couse
I add file with insert statements

teldpaip.sql.zip /deleted/

the codepage is win1251 or cp1251

[vityah1]

Hi
Have a nice day
Happy 2022 NY :)
Do you find some solution for this situation?
Thanks

[adamghill]

Sorry, I finally inserted your SQL and tested on my local. Everything looks pretty quick to me? You can see the Python print statements and then the console log is almost instantaneous.

I'm only testing on local and with a SQLite database, though.

[vityah1]

Thanks for answer.
So, I don't have any idea why it work so slowly for me.
As I see. Database work quick. But python + django+unicorn on windows platform work slow.