Inserting nothing takes a long time

Hi,
I've a strange problem with a INSERT query. It's taking a long time to
execute. The format is like this :

INSERT INTO table1
SELECT ..
FROM table2

Executing the SELECT .. FROM table2 is taking 30 seconds. The result
is nothing: no records are selected.

When i include the INSERT part it will take 12 hours to complete

INSERT INTO table1
SELECT ..
FROM table2

There's is an index on the table and when i delete it, it gives still
the problem.

Keh?

Greetz,
Hennie
.

Relevant Pages

  • Re: HOWTO: Use conditions in FROM clause in Access sintax.
    ... If you execute them in SQL Server I ... and that means that I need all rows in Table1 and only matching one in ... >> Table2 Ref RefExt RefTwo Data ...
    (microsoft.public.access.queries)
  • Re: Call SqlCommand.ExecuteReader inside another SqlCommand.Execut
    ... Do you mean that you are concerned that a row of interest in table2 could be ... updated after you execute the select on table1 but before you execute the ... begin transaction; ...
    (microsoft.public.dotnet.framework.adonet)
  • Confirmation of Execution of SQL code
    ... This method is, after inserting some data to table1, after a button click event or any other event makes these entered data to be exported to table2. ... and made to Execute at Run time when the user presses the export button. ...
    (borland.public.delphi.database.ado)
  • Re: Image::Magick trouble
    ... >>Hi I just install ImageMagick for windows and I got a strange problem ... >>I can execute demo.pl but when I try to edit it and execute with Komodo ... > And that truth is that something may have changed in your environment, ...
    (comp.lang.perl.misc)
  • Re: Stored Procedure executes very slow, code pasted into query-analyzer executes fast?
    ... >> I am currently facing a strange problem. ... I execute a stored procedure ... >> runs thousand times faster. ...
    (microsoft.public.sqlserver.programming)