遇到高并发,多条件单表查询瓶颈,求大神指点指点
问题解释如下:该表为客户发布信息的表,表内Message字段存储客户发布的信息,当前同时在线人数上千,高并发查询,以及客户查询关键字较多,一般为城市,比如查询条件有上百个,对于这样的,只查询这一个表里的message字段,如何处理,求大神指点,小弟感激之至!下边为查询条件
City='济南' and ( 1!=1 or MessageContent like '%安丘%' or MessageContent like '%昌乐%' or MessageContent like '%昌邑%' or MessageContent like '%高密%' or MessageContent like '%临朐%' or MessageContent like '%青州%' or MessageContent like '%寿光%' or MessageContent like '%潍坊%' or MessageContent like '%诸城%' or MessageContent like '%安丘%' or MessageContent like '%昌乐%' or MessageContent like '%昌邑%' or MessageContent like '%高密%' or MessageContent like '%临朐%' or MessageContent like '%青州%' or MessageContent like '%寿光%' or MessageContent like '%潍坊%' or MessageContent like '%诸城%' or MessageContent like '%陕西%' or MessageContent like '%安康%' or MessageContent like '%安康%' or MessageContent like '%白河%' or MessageContent like '%汉阴%' or MessageContent like '%岚皋%' or MessageContent like '%宁陕%' or MessageContent like '%平利%' or MessageContent like '%石泉%' or MessageContent like '%旬阳%' or MessageContent like '%镇坪%' or MessageContent like '%紫阳%' or MessageContent like '%宝鸡%' or MessageContent like '%宝鸡县%' or MessageContent like '%凤县%' or MessageContent like '%凤翔%' or MessageContent like '%扶风%' or MessageContent like '%麟游%' or MessageContent like '%陇县%' or MessageContent like '%眉县%' or MessageContent like '%岐山%' or MessageContent like '%千阳%' or MessageContent like '%太白%' or MessageContent like '%城固%' or MessageContent like '%佛坪%' or MessageContent like '%汉中%' or MessageContent like '%留坝%' or MessageContent like '%略阳%' or MessageContent like '%勉县%' or MessageContent like '%南郑%' or MessageContent like '%宁强%' or MessageContent like '%西乡%' or MessageContent like '%洋县%' or MessageContent like '%镇巴%' or MessageContent like '%丹凤%' or MessageContent like '%洛南%' or MessageContent like '%山阳%' or MessageContent like '%商南%' or MessageContent like '%镇安%' or MessageContent like '%柞水%' or MessageContent like '%铜川%' or MessageContent like '%宜君%' or MessageContent like '%白水%' or MessageContent like '%澄城%' or MessageContent like '%大荔%' or MessageContent like '%富平%' or MessageContent like '%韩城%' or MessageContent like '%合阳%' or MessageContent like '%华县%' or MessageContent like '%华阴%' or MessageContent like '%蒲城%' or MessageContent like '%潼关%' or MessageContent like '%渭南%' or MessageContent like '%长安%' or MessageContent like '%高陵%' or MessageContent like '%户县%' or MessageContent like '%蓝田%' or MessageContent like '%临潼%' or MessageContent like '%西安%' or MessageContent like '%周至%' or MessageContent like '%彬县%' or MessageContent like '%长武%' or MessageContent like '%淳化%' or MessageContent like '%泾阳%' or MessageContent like '%礼泉%' or MessageContent like '%乾县%' or MessageContent like '%三原%' or MessageContent like '%武功%' or MessageContent like '%咸阳%' or MessageContent like '%兴平%' or MessageContent like '%旬邑%' or MessageContent like '%永寿%' or MessageContent like '%安塞%' or MessageContent like '%富县%' or MessageContent like '%甘泉%' or MessageContent like '%黄陵%' or MessageContent like '%黄龙%' or MessageContent like '%洛川%' or MessageContent like '%吴旗%' or MessageContent like '%延安%' or MessageContent like '%延长%' or MessageContent like '%延川%' or MessageContent like '%宜川%' or MessageContent like '%志丹%' or MessageContent like '%子长%' or MessageContent like '%定边%' or MessageContent like '%府谷%' or MessageContent like '%横山%' or MessageContent like '%佳县%' or MessageContent like '%靖边%' or MessageContent like '%米脂%' or MessageContent like '%清涧%' or MessageContent like '%神木%' or MessageContent like '%绥德%' or MessageContent like '%吴堡%' or MessageContent like '%榆林%' or MessageContent like '%子洲%'