Re: Need speed
From: Wolfgang Schmale (Spamkocher_at_strang.lt)
Date: 06/09/04
- Previous message: Scott: "Need speed"
- In reply to: Scott: "Need speed"
- Next in thread: Scott: "Re: Need speed"
- Reply: Scott: "Re: Need speed"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 9 Jun 2004 22:40:25 +0200
Hi Scott!
Did you already try to eleminate the view and to use a buffered table.
Another issue is where the table is stored. In other words is the table
local or on a network machine?
Is it necessary for you to do your calculations prior saving the data into
the table? Or is it possible to insert the data first and then do the
calculation?
--
----------------------------------------------
Mit freundlichen Grüßen
Wolfgang Schmale
[MVP für Visual FoxPro]
--------------------------------------------
"Scott" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag
news:C5456960-0470-45BE-A824-29DD7B01BA40@microsoft.com...
> I'm importing a bunch of pay records into a table ('PAY TABLE') with
already contains over 10,000 records. I create an updatable View of the Pay
Table and set 'Table Buffering' on.
> The View is parameterized to the current pay period only and is where I
import all the new records into as well as do the calculations for them. The
more the records added, the longer the process is taking!
> Once the process is complete, I issue a TABLEUPDATE(.T.) (all rows)
command to the View thereby commiting all the new/modifed records to the pay
table. At first, I thought it was all my calculations that were slowly down
the process. It turns out that it's the saving part that is REALLY slow. Am
I doing something wrong?
- Previous message: Scott: "Need speed"
- In reply to: Scott: "Need speed"
- Next in thread: Scott: "Re: Need speed"
- Reply: Scott: "Re: Need speed"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
