>I have a parent table and child table that are being updated through a view. The parent table has roughly 500,000 records and the child has around 300,000 records. (the parent table is used in other applications, that's why it's larger) I'm able to insert most of the data directly into the tables before I open the view. I buffer the view with CURSORSETPROP with buffering set to 5 (optomistic table). I replace four or five pieces of information in the view and commit the changes through a tableupdate(.t.). It is taking around 1 minute to commit the changes back to the tables. There are about 100 people hitting the system adding about 5000 records a day, but the server nor the network is being taxed. (or so I'm told)
>
>I find it interesting that the SQL Inserts into the parent and child tables are not taking any time, but the tableupdate() from the view is. I have the view set to do SQL-Updates on Key and Modified fields.
>
>Any suggestions?
>
>TIA,
>Tom Harker
We have the same problem where I work. < g >. You knew I'd reply with this, didn't you.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer