Re: Need speed

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Scott (Scott_at_discussions.microsoft.com)
Date: 06/10/04 

Date: Thu, 10 Jun 2004 06:57:01 -0700

The database is located on a network server. This is also a multi-user app.
Currently, I am opening the tables and inserting/modifying straight to them. Buffering is set to '1'. The obvious problem here is that more than one user is running the same process at once (on a different set of records mind you). Performance with this is slow, so I was hoping that using (local) views with table buffering would speed things up.

"Wolfgang Schmale" wrote:

> 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?
>
>
>

Relevant Pages

  • Re: Keeping and caculating historically correct data?
    ... > employee through a certain date.... ... results and delete the elements of the calculations. ... > corresponding rate for each day in the pay period. ...
    (comp.programming)
  • Re: Negotiated fee rate
    ... Are they hiding the relatively low rates from the uninsured? ... >>have to pay a bill without the evidence of the calculations used? ... > held close to the vest by the insurer. ...
    (talk.politics.medicine)
  • Re: simple formatting
    ... Once in the new number fields i will do the calculations ... a Number or Currency datatype field. ... data, then you will have unending problems with calculations, with data ... Your choice - pay now, ...
    (microsoft.public.access.formscoding)
  • Re: simple formatting
    ... Once in the new number fields i will do the calculations ... a Number or Currency datatype field. ... data, then you will have unending problems with calculations, with data entry, ... Your choice - pay now, ...
    (microsoft.public.access.formscoding)
  • Re: simple formatting
    ... Once in the new number fields i will do the calculations ... a Number or Currency datatype field. ... data, then you will have unending problems with calculations, with data entry, ... Your choice - pay now, ...
    (microsoft.public.access.formscoding)