Performance Issue
-
As performance issue, what is the appropriate approach to write a code which select records from the database into array and then filter them or filter the data while running the query on the database. In other words, Does running mathematical operations and filtration (like WHERE ..) on database side better than doing it on the application side?
Faris Madi Nothing Comes Easy (N.C.E.)
-
As performance issue, what is the appropriate approach to write a code which select records from the database into array and then filter them or filter the data while running the query on the database. In other words, Does running mathematical operations and filtration (like WHERE ..) on database side better than doing it on the application side?
Faris Madi Nothing Comes Easy (N.C.E.)
Absolutely, that is what the database is for, that is what it is optimised to do.
Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )