Re: Very long to to insert a row in an Oracle linked server

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Sat, 7 Jul 2007 19:08:01 -0700, Peter Jones
<PeterJones@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hi Bob,

Why is it necessary to go through SQL Server in the first place?

Well the app that supplied the data lives on a W2K3 server using a SQL
Server 2000 database and, when the client as for this data export facility,
is was 'easy' to integrate into the exisiting app by simply executing a SQL
Server 2000 stored proc that extracted the required info and simpy did an
insert against the Oracle database which was mapped as a linked server in SQL
Server 2000, e.g.

INSERT INTO Oracle..TMS.TMS_PACKINGLIST_DTL ( etc etc

I would be really interested in any suggestions re an alternate approach.

Cheers, Peter



OK ... does the stored procedure use bind variables and a prepared
statement for the insert, or does it issue 10 different queries with
everything in plain text? If you can, you should do it with a
prepared statement; that way, the server only needs to parse it once.

--
Bob Hairgrove
NoSpamPlease@xxxxxxxx
.

Relevant Pages

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)