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? 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? 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 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. Link to comment https://forums.phpfreaks.com/topic/143247-sql-where-clause/#findComment-752458 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.