>I'm not sure what index bloat means???? We have re-indexed many times, re-created indexes many times. The views are built into the dbc and as far as I know just using the select statement from the command window produces the same performance. Recall that I'm talking about a very simple test using custno. SBT, skyline, etc use the same index tag - just plain custno - on the table arcustXX. We have tried moving the table to MS-SQL on a test computer and found a marked improvement. But to get the performance really wanted we have used seek's. I wish fox advisor would do a test on this type of situation. And of course find how, why and when views are slow using foxpro tables. Thanks for your help. In fact today (sat) we will be doing more testing because it is driving us crazy.
>John

I can work with ARCUSTXX.custno and give you some feed back Monday or Tues.

Index bloat is where the tags are still left in the cdx file and new ones are added.

Index on custon tag custno
index on custno tag custno addi

Does the same thing but the first is still in the cdx.

dele tag custno
index on custno tag custno addi

That removes the former and then rewrites it. Try doing that and see the size of your cdx get smaller?

A customer file of 50,000 + customers should be a second at most to get a customer! Or to get all active customers for that matter.

My credit check views are really quick. And they link to a secondary in house file so I can apply a hold on building product, shipping a finished good or shipping a replacement part.

The pageframe has 2 pages. Page 1 is a grid of all customers in a credit violation, and the supporting detail to show the user. Page 2 allow the user to adjust a hold so we can ship parts to that customer, but not any new product.

Now my views for Credit data are based off the credit hold data. Every time a user goes into credit hold I recalc the current status by running through arcust for balance >= limit where limit >0. This creates a table that the view is based off of. This process only takes about 10 20 seconds, ok maybe a min but there is a progess bar running through the scan on validation and it gives the user a calm feeling.