az
V2EX  ›  问与答

MySQL Delete 优化求教

  •  1
     
  •   az · Feb 23, 2016 · 2418 views
    This topic created in 3757 days ago, the information mentioned may be changed or developed.
    DELETE from translation_entries where id in
        (select entry_id from translation_map where key_id in 
            (
                select id from translation_keys where package_id = 'package_id'
            )
        )
    

    这一句连用了几个 where in ,速度很慢,如果优化?

    1 replies    2016-02-23 17:08:39 +08:00
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   1186 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 29ms · UTC 17:25 · PVG 01:25 · LAX 10:25 · JFK 13:25
    ♥ Do have faith in what you're doing.