djangoã®QuerySetã§å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’扱ㆠ- logiqboardメモリã«è¼‰ã‚Šåˆ‡ã‚‰ãªã„よã†ãªå¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’扱ã†ã¨ãã¯ä½•ã‹ã—らã®å·¥å¤«ãŒå¿…è¦ã§ã€djangoã®QuerySetも例外ã§ã¯ã‚ã‚Šã¾ã›ã‚“。 ç°¡å˜ãªä¾‹ã¨ã—ã¦ã€ä»¥ä¸‹ã®ã‚³ãƒ¼ãƒ‰ã‚’メモリãŒå¤šããªã„環境ã§å®Ÿè¡Œã™ã‚‹ã¨ã€ãƒ«ãƒ¼ãƒ—ã«å…¥ã‚‹å‰ã«ãƒ¡ãƒ¢ãƒªã‚’ドカ食ã„ã—ã¦è½ã¡ã¾ã™ã€‚ many_many_objs = MyDBLog.objects.all() # 1億件ãらã„ã‚ã‚‹ã¨ã™ã‚‹ for log in many_many_objs: print(log.body) ã©ã†ã™ã‚‹ 件数ãŒå¤§ãããªã‚Šãˆã‚‹QuerySetを扱ã†å ´æ‰€ã§ã¯ã€QuerySetを分割ã—ã¦æ‰±ã†ã‚ˆã†ã«ã—ã¾ã™ã€‚ QuerySetã¯ã‚¹ãƒ©ã‚¤ã‚¹ãŒä½¿ãˆã‚‹ã®ã§ã€ã†ã¾ã活用ã—ã¾ã—ょã†ã€‚ def chunked(queryset, chunk_size=1000): start = 0 while True: chunk = queryset[start:start + chunk
Python Developers Festa 2012.07 ãƒãƒ³ã‚ºã‚ªãƒ³ åˆç´š — Python Developers Festa 2012.07 documentation
fabfileã®æ§‹é€ 化 - logiqboard
一週間ノマドやã£ã¦ã¿ãŸ - logiqboard
{{#tags}}- {{label}}
{{/tags}}