About simonlawrence

simonlawrence · 04-05-2016

Hi everyone - Really could do with some advice, so here's hoping someone out there has encountered a similar issue to ourselves.I run reports that use the INCIDENT table, and there are about 170000 records within it. We run reports that analyse thi...

simonlawrence · 05-27-2016

Well, that approach works kinda well if you want to download all the records all at once. This is my (hopefully final) approach that uses DynamicSQL and only pulls back changes (modifies incidents and new incident records) to a local "master" copy:...

simonlawrence · 05-27-2016

HI Simon - Just thought id give you a quick update - ive followed your advice and made a delta-update method. Its vastly superior - its more robust as it needs less data per query, I just run it very frequently (currently set to every 5min), but I ...

simonlawrence · 04-06-2016

Si - Youre a star. I'm liking that method. Nifty sidestep of the problem of working out what actually changed. Heh.Added to my "stuff I'm gonna do" list.Rock On!-S.

simonlawrence · 04-06-2016

I'll bookmark this.. I suspect I'll be coming back to this in the future. Well, so far - my 6 queries and the "try , try and try again!" logic seems to be holding. For how long - don't know. If the problems I'm having with ODBC are primarily do...

simonlawrence · 04-06-2016

Just for anyone's reference, in case it helps with "readers of this thread in the future", my stored procedure that does the retry in the event of a query failure is posted below, in case it helps, or is useful to someone somewhere somehow:alter ...

User Activity

ODBC Driver reliablity and performance issues - can data be bulk downloaded without ODBC?

Re: ODBC Driver reliablity and performance issues - can data be bulk downloaded without ODBC?

Re: ODBC Driver reliablity and performance issues - can data be bulk downloaded without ODBC?

Re: ODBC Driver reliablity and performance issues - can data be bulk downloaded without ODBC?

Re: ODBC Driver reliablity and performance issues - can data be bulk downloaded without ODBC?

Re: ODBC Driver reliablity and performance issues - can data be bulk downloaded without ODBC?