Posted by Wes Groleau on 02/03/07 05:08

Erland Sommarskog wrote:
> To be able to say something more useful, I would be able to see
> the CREATE TABLE statements for the tables. (Or is there only one?),
> as well as the indexes, including keys. And of course I would need
> to know your UPDATE statements. And if there are any triggers, I
> need to see those as well.

Sorry for the too-soon send.

As I said, I did the table design with the GUI but it would be equivalent to
( CAS_Seg int,
SVC_Seg int,
CLP_Seg int,
BPR_Seg int,
other fields )

CAS_Seg is loaded first, with an INSERT from a view of Raw_Segs.

Then BPR_Seg is updated with the highest Seg_Nbr lass than CAS_Seg in
the same file. Works.

Then one of the updates I just sent is tried and times out.

--
Wes Groleau
------
"The reason most women would rather have beauty than brains is
they know that most men can see better than they can think."
-- James Dobson

[Back to original message]