az
V2EX  ›  问与答

MySQL Delete 优化求教

  •  1
     
  •   az · Feb 23, 2016 · 2416 views
    This topic created in 3756 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   ·   2943 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 32ms · UTC 06:54 · PVG 14:54 · LAX 23:54 · JFK 02:54
    ♥ Do have faith in what you're doing.