Skip to content
  • Categories
  • Tags
  • Popular
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (Flatly)
  • No Skin
Collapse

Odoo 中文社区

  1. Home
  2. Categories
  3. 集思广益
  4. 大数据量批量处理效率问题(悬赏5w人民币)

大数据量批量处理效率问题(悬赏5w人民币)

Scheduled Pinned Locked Moved 集思广益
6 Posts 4 Posters 4.6k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • V Offline
    V Offline
    vr.martin
    wrote on last edited by
    #1

    目前使用odoo实施erp项目,明细库存移动数据每天5w明细行左右,产生凭证行将近10w行,导致业务数据太多,查询问题效率非常低下,同时客户也不希望系统存贮这么多明细行;而且后续需要把一些凭证行进行计算进行分摊,导致效率非常低下,希望大牛能够帮忙解决,不胜感激

    1 Reply Last reply
    0
    • 木 Offline
      木 Offline
      木子日月
      wrote on last edited by
      #2

      我可以解决。不过5W太低了。美元可以吗?

      1 Reply Last reply
      0
      • L Offline
        L Offline
        lcgcg
        wrote on last edited by
        #3

        @vr-martin 在 大数据量批量处理效率问题(悬赏5w人民币) 中说:

        希望大牛能够帮忙解决

        毕竟数据量太大,只停留在技术上已经不行,所以5W美元不算多

        1 Reply Last reply
        0
        • ieitzybI Offline
          ieitzybI Offline
          ieitzyb
          wrote on last edited by
          #4

          所以,我选择用汇总的库存模式即传统3表,不用标准的1表,就是这个担心。

          http://www.OuduPLM.com/ 苏州欧度软件,专注服装行业(鳴謝:37signals,Trello,ProcessON,重庆慧积,上海开阖)

          L 1 Reply Last reply
          0
          • L Offline
            L Offline
            lcgcg
            replied to ieitzyb on last edited by
            #5

            @ieitzyb 怎么讲,能否说的明白点,什么三表,一表

            1 Reply Last reply
            0
            • ieitzybI Offline
              ieitzybI Offline
              ieitzyb
              wrote on last edited by
              #6

              1入流水 - 2出流水 - 3存汇总,Odoo的仓库超级抽象=1个库里移来移去。
              都忘记最大的差别了,我们把仓库都完全分开了,成品、原料,为了用户有个更趁手的工具、更好用,只好不要太抽象通用 。

              http://www.OuduPLM.com/ 苏州欧度软件,专注服装行业(鳴謝:37signals,Trello,ProcessON,重庆慧积,上海开阖)

              1 Reply Last reply
              0

              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Tags
              • Popular
              • Users
              • Groups