Stored procedure takes too much time in if statement when i pass @ip='' and takes 0 sec with some value to @IP

Stored procedure takes too much time in if statement when i pass @ip=''
and takes 0 sec with some value to @IP

References

Reference NO 1

http://stackoverflow.com/questions/15197839/stored-procedure-takes-too-much-time-in-if-statement-when-i-pass-ip-and-take

Reference NO 2

http://stackoverflow.com/questions/13958264/subquery-in-declare-statement-brings-back-more-than-one-value

Reference NO 3

http://stackoverflow.com/questions/10720397/stored-procedure-execution-take-too-many-times

Reference NO 4

http://stackoverflow.com/questions/17398401/how-to-retrieve-data-from-database-when-i-have-option-of-4-parameters-using-stor

Reference NO 5

http://www.bigresource.com/MS_SQL--How-to-speed-up-batch-insert-MSSQL--mSAAS7lE.html

Reference NO 6

http://en.wikibooks.org/wiki/Tomato_Firmware/Installation_and_Configuration

Reference NO 7

#EANF#

Reference NO 8

#EANF#