S
sekhar veesam
Guest
We have a requirement that sending the SMS to customers in bulk around 5/6lakhs...
We have written console job which will pick the records from database and inserting the same customers in DB table, then from DB table, seperate job will pick and send the SMS to third party service. While inserting customer ids (around 2Lakhs) in the DB table, getting SQL TIme out exception. Please provide us the better approach for achieving this functionality.
Please refer the below steps in detailed
step 1: getting around 2 lacs of customer id's from data base
step 2:convert those customer id's to string type with comma separated format
step 3:sending back to comma separated string to data base
step 4:in data base, split this string based on commas and inserting into data base tables
we are sending SMS for those customers but getting sql time out exception
Please give the better approach for this.
phani
Continue reading...
We have written console job which will pick the records from database and inserting the same customers in DB table, then from DB table, seperate job will pick and send the SMS to third party service. While inserting customer ids (around 2Lakhs) in the DB table, getting SQL TIme out exception. Please provide us the better approach for achieving this functionality.
Please refer the below steps in detailed
step 1: getting around 2 lacs of customer id's from data base
step 2:convert those customer id's to string type with comma separated format
step 3:sending back to comma separated string to data base
step 4:in data base, split this string based on commas and inserting into data base tables
we are sending SMS for those customers but getting sql time out exception
Please give the better approach for this.
phani
Continue reading...
