I have 2 tables with nearly 10000 records .When i am using django views to update/insert records, it is taking more than 5 seconds . I am using bulk_create and bulk_update to insert and update maximum 5 records at a time .Any suggestions will be helpful .
Forums
Slow update and insert in mysql .
varun0109
|
4
posts
|
Is it always slow or only sometimes?
fjl
|
4614
posts
|
PythonAnywhere staff
|
once the table size increased over 6000 records it got slow
Have you tried to inspect the query that django is generating for you? 6k records does not sound like something problematic.
I had a problem in my code . it is working fine now .Thanks
Glad to hear that, thanks for letting us know!
