Viewing 15 posts - 1 through 15 (of 174 total)
The Oracle team determined that the driver was basically still doing a row by row insert instead of batch.
In the meantime, we decided to setup an Azure database with the...
April 3, 2024 at 1:55 pm
Duplicate reply my first one took a while to show up...
March 28, 2024 at 4:37 pm
Sincerely appreciate all of the replies.
We've started down the path of creating a C# program that uses the Oracle’s 19c drivers - and performance is definitely much, much better; in...
March 28, 2024 at 4:30 pm
Appreciate the replies!
The script I used most recently is this:
declare @period varchar(10) = '2024MAR'
declare @innerCommand varchar(500) = 'select * from FACT_GL_ACTUALS where TRX_PERIOD = ''''' + @period...
March 19, 2024 at 12:55 pm
Thanks all...
I tried using a dynamically generated openquery statement and, while it's not as fast as I was hoping, it's definitely a lot faster than before. Going to try to...
March 18, 2024 at 3:17 pm
We're not joining to anything local, fortunately. We're literally just dumping the contents of reporting tables on our server to a tables on their server - the only difference being...
March 15, 2024 at 7:59 pm
In this particular instance, my local PC is the server - right now we're just trying to see if we can actually make the connection.
Everything is 64-bit including the driver. ...
December 7, 2023 at 9:36 pm
Just in case anyone is curious or has the same problem - the solution provided by bpflanzer works perfectly. I've tested it a couple of times now in our test...
July 26, 2023 at 1:24 pm
Appreciate the help... the @sync_type suggestion from bpflanzer seems to work exactly how I'd hoped.
I am bit nervous about the fact that the first time I tried, I setup a...
July 17, 2023 at 8:02 pm
Fortunately the powers that be have agreed that replication isn't the way to go... mostly because this database was one of six with that many objects; and if one giving...
May 19, 2023 at 1:34 pm
The business case initially is to have a readable copy out on our Azure environment. Eventually, we will be moving our application to Azure, which is why we need to...
May 15, 2023 at 3:29 pm
The table is usually between 1500-3000 rows, so not big at all. It's fairly simple to just cut and paste an INSERT from SSMS.
I was just trying to avoid those...
May 5, 2023 at 5:15 pm
The table in question is truncated and repopulated in the production environment at the end of each month. It contains data that is compiled in other systems; the exact date...
May 5, 2023 at 3:30 pm
Thanks all for the replies...
The second server in this case is on an environment that is essentially an exact snapshot of our production environment, which is taken over the weekend. ...
May 5, 2023 at 12:49 pm
That's what I was thinking, thanks for confirming.
May 3, 2023 at 5:44 pm
Viewing 15 posts - 1 through 15 (of 174 total)