Re: DELETE FROM - Somethings not right

Thank you both for your replies. I should note that the table was
populated from a C# application and I loaded the 300,000 records in 3
minutes which I was very impressed with. There are other tables that
got data added to it, like KnownBy and CustomerActivity. Now that I
think of it, I deleted the child rows from those two tables before I
tried to delete the customer rows and those went fairly quick. So,
something else must be wrong.

I dont understand what SPID is, but I did see a value of 51 in the
properties of the query. I'll look into that. I ran the sp_who and the
blk column was 0 for all rows. There are a lot of tables that are
children of the customer table, but I would have to think that they are
all indexed. Once I find the indexes I'll let you know (pretty
unfamiliar with 2005 from 2000). FYI - there isn't any data in any of
the other tables for these customers I want to delete, but there are
about 4 million orders for the other 2.3 million customers.

I ran the process again after I posted the message last night using
this code: Delete from customer where custid > 2298595. Again, 9 hours
later still running. I looked at the properties of the Customer table
and the row count was what I wanted at 2298594. And like a dummy I
cancelled the query then and it rolled back. LOL. I found out it's
different from 2000 since 2005 rolls back.

.

Relevant Pages

  • Re: Trouble with sendkeys - Alternative?
    ... One customer can be involved in many sales (but not ... You can then create a query based on your three tables. ... If you want to include the sum of the "Value" columns in a crosstab query, ... Graham Mandeno ...
    (microsoft.public.access.formscoding)
  • Re: Crosstab query by quarter nightmare
    ... The Cartesian query gives every combination of customer and savings in the ... I am getting the same count for each savings. ... So you are recording when a customer came on board. ... So the whole crosstab relies ...
    (microsoft.public.access.queries)
  • Re: [PHP] OOP slow -- am I an idiot?
    ... OOP has overhead. ... That saves you putting wasteful SQL queries in your ... If you need to do a complex query with a couple of joins and such, ... I want to create a "customer" class which fetches its attributes from a ...
    (php.general)
  • Re: Many-to-Many relationship Query
    ... the key value is a text string and not a number. ... FROM Employee INNER JOIN (Customer INNER JOIN ... The following function reads this Query and produces a list of employee names similar to what you asked for. ... EmpByCustAS Employees ...
    (microsoft.public.access.queries)
  • RE: Search facility query
    ... "Klatuu" wrote: ... The name of the control on the popup form for customer name ... The name of the table or query that is the record source for the main form. ... Set rstClone = Me.RecordsetClone ...
    (microsoft.public.access.modulesdaovba)