Karen, In your use case, large text fields shouldn't be a problem. I would install the django-toolbar and use the reporting to determine if a particular query or template is causing the slowdown.
Are you displaying the large text field in the admin list view? If you are and the view template is using a table, the browser won't display the table until all the data is rendered, that could be the cause of your slowness. On Jan 31, 2011, at 5:22 PM, Karen McNeil wrote: > I've created an application to manage texts, storing the content in a > TextField, along with metadata in other fields. Now that I've > completed the model and started actually adding the texts, the admin > is getting verrrry slow. The app is just for the use of me and my > team, so the slowness is not a deal-breaker, but it's annoying to work > with and I still have a lot of texts to add to the corpus. > > Although I may be adding a large amount of smaller texts in the > future, the texts that I have now are large, mostly in the tens of > thousands of words, with the largest currently at 101,399 words. > (Which I know because I added a method to the model to calculate the > wordcount, and have it displayed in the admin list. Which gives me no > end of pleasure.) > > So, is it a bad idea to be storing texts this large in a database > field? I really hope not, because when I first started this project > (granted, before I started using Django), I was reading the data from > files and running into constant encoding/decoding problems. (These > texts I'm collecting are in Arabic.) > > If it's not a totally horrible idea to do this like I'm doing, is > there anything I can do to improve performance? I tried implementing > caching and it didn't make any difference. > > Thanks, > Karen -- Eric Chamberlain, Founder RF.com - http://RF.com/ -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
