Have Geek Brain

Mysql too many while loops inside one stored procedure

I have one stored procedure, while I am getting comma separated values ​​in parameters. I have three parameters that have comma separated values. and i need to put them in table columns, so i use while loop. but I'm afraid when too many (say lakh users) users connect to my site, then my procedure will have performance issues.
Does anyone have a better solution for this problem?

Thanks in advance. Regards,
MySQL DBA

0


a source to share


1 answer


SQL is interpreted even though it is said to be "compiled". This means your code can run faster if you just split the strings outside the DB and do multiple inserts instead of a single SQL-proc call that uses interpreted SQL loops through the input.



0


a source






More articles:


All Articles