I have written a procedure where i Find Members Id via Loop and check certain condition and If condition true
Then use insert statement.
I have use basic code
create procedure procName
select ids from members order by ids
in Member Table there is One Lakh Sixty Seven Thousand Data.
when i execute this procedure, mean while
i execute members query , it does not execute till my procedure complete process.
Procedure take time 5 to 6 hrs.
I seem that due to begin- end and Commit or rollback , reason it locks another process.
and it takes more memory till execution the process.
please help me to reduce time and minimum memory allocation
and select query execute when procedure runs