Re: SQL suggestion requested
Quote:
Originally posted by xargon
Hi everyone,
I am developing an application that needs to do multiple writes many tables in the database. I will explain the structure of the tables and what I am doing:
Right now, I make an entry for every new data. There could easily be more than 40,000 entries for each application run. I would have liked to store the entries in memory (in an array) and would like flush them out in one stored procedure. The only glitch is that I do not know if stored procedures can handle C++ arrays.
I saw many articles on the web about using comma seperated strings etc and passing it to the stored procedure. However, I am always wary of strings, especially hige concatenations. I was wondering if someone has any experience regarding this and what would be the best course of action. The performance of the application right now is almost unacceptable and I would like to optimize it before it grows out of bounds.
Thanks a lot.
Xargon
You can only
use the concatinated method as long as the submitted data length will not exceed 8000 bytes (char/varchar type limit).
If this is for inserts only then use ADO to create your connections, recordsets and commands then you can configure so you can run the SP over and over and limit the chatter to some extenmt.
If you can give a bit more detail on the logic and what you are doing as far as flow I can provide a small example of code that might help.