August 23, 2013 at 4:35 pm
Hello,
I am trying to mail merge a document over an SSL VPN connection. I can open a Word doc that is on our server, but when I try to mail merge the document, it freezes, or takes about 30 seconds to search 200 records. We have 16,000 records... When I'm in the office it take 2-3 seconds to mail merge.
I am using a word data source that connects to a view on our SQL server. I have tried recreating the mail merge with Schema binding so I could create a unique Clustered Index on the base table's primary key, which is also the field we use to search for our records.
This they anything I can do to speed things up? I'm open to idea's...
As always any help is greatly appreciated,
David92595
August 28, 2013 at 5:34 pm
Just a thought... what if you used bcp or something to crank the resultset into either csv or Excel, and then used that as a source instead of the DB directly? The part I would worry about was keeping the connection open when you really don't need to. Clearly the downside to that is a data "leak"...
August 28, 2013 at 5:48 pm
yea, my higher ups definably wouldn’t go for that. We house sensitive bank information, so any chance of a data leak is out.
I did get a response from another site, though the person who gave the suggestion never came back to the thread after I asked a follow up question. So I will pose it to you and see if you can find a way to implement his idea.
He said I'd be better off breaking the process ino two phases: first, loading on the information my useres need to chose the ID
SELECT ID, ContactName FROM "SQL Mail Merge";
Then Second, run the actual mailmerge
SELECT * FROM "SQL Mail Merge"
WHERE ID = [variable containing the selected value];
but I have no idea how I would implement this...
David92595
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply