I have been asked to extract information from an SQL Server 2000 database and create Notes documents. One of the first things I need to do is get a list of IDs from a particular table and then for each ID record returned, get the required information, for that ID, that is stored in other tables.
Now, the IDs I need to read are in a table and there are heaps of them, so much so the result set would be too big to return. I was wondering if anyone had had experience with processing lots of data, using LSXLC. Did you use a stored procedure or another method to get around the problem of too many records being returned.
Any information, links, suggestions etc would be very much appreciated.
I did think abt processing ranges and that would work just fine, I think. Will try it out tomorrow.
Also sounds like the result set can return quite a records so I should be right. I don’t expect to ever get more than 25K records returned, but you never know, hence the processing by ranges sounds like a way to go.
If I come across another way of doing this in my LSXLC travels I will certainly let this forum know.
I “syncronize” 600.000 records from DB2 to Notes using ODBC, it takes about 1 second for 1000 records. I use “Select …” query to fetch the data.I did same thing in LCX LC, but I didn’t try with more than 100.000 records. I used same “Select…” query there as well.