I am working with a client on a SQL 2000 box which is being accessed by a VFP 8 app.

We are having slowness problems. Not every SQL table has PKs or indexes. VFP is requesting data via inline SQL. In addition, it appears that each client has between 22 and 40 SQL handles.

What is the best practice to get the SQL handle count down? It has been awhile since I've been in VFP code, let alone VFP 8.

So I'm setting up profiler to catch the SQL in a trace. I'm running SQL to see which tables don't have PK. I'm checking table and index fragmentation.

What else can I do to get this up to speed?

Thanks,
Doug