Originally Posted by arnyinc
You would still need to connect to the sql server to execute a stored procedure on the web server. I assume they want to stop you from executing arbitrary sql commands. So you can create a stored procedure that is "hard coded" in the sql server. Then you can only call this pre-defined stored procedure so they know what you are executing.
i got another problem about the performance of process.
currently i want continue with the project that had done by other developer.
Process getting data from SQL server compare with get from MYSQL will more slow?
i ask this question is because previous developer want to keep the previous history record so every day get data from SQL server and insert into MYSQL and cause MYSQL got thousand of record.
this also cause the application run very slow when user perform certain funtions.
any suggection for to correct it?