orange08 Posted January 31, 2009 Share Posted January 31, 2009 if my SQL SELECT statement WHERE clause has about 7 OR conditions, will it slow down the searching speed? Quote Link to comment https://forums.phpfreaks.com/topic/143247-sql-where-clause/ Share on other sites More sharing options...
revraz Posted January 31, 2009 Share Posted January 31, 2009 Compared to what? Quote Link to comment https://forums.phpfreaks.com/topic/143247-sql-where-clause/#findComment-751372 Share on other sites More sharing options...
FezEvils Posted January 31, 2009 Share Posted January 31, 2009 depend on how many data do you have, let said for 2 millions data, so it will take a time to process complex sql Quote Link to comment https://forums.phpfreaks.com/topic/143247-sql-where-clause/#findComment-751487 Share on other sites More sharing options...
fenway Posted February 2, 2009 Share Posted February 2, 2009 Yes, OR is slow.. maybe index_merge will help. Quote Link to comment https://forums.phpfreaks.com/topic/143247-sql-where-clause/#findComment-752458 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.