Hi Kevin,

>One of my applications runs in various sites and one of them has a performance issue with just 1 of the tables.
>
>This table is identitical to all the others, but for some reason when I run a query on it, it takes around 4 times as long, this is the same case for the users on the LAN.
>
1. When you say 'identical' do you mean to the others at that site or to ones at other sites?

2. I presume when you say 'identical' that you mean structure-wise. Correct?

3. How many records are in the poorly performing table, and how does that record count compare to other tables and other sites?

4. Does the table in question have lots of deleted records or few/none?

5. Do you have a TAG on deleted defined for the table?... all the others too?

6. I presume that your query is using SQL-Select. Is this correct?

7. When you say 'identical' do you include the index/TAG definitions in that?

8. From your statement "it takes around 4 times as long, this is the same case for the users on the LAN" I presume that *you* run local when you try it. Correct?

The above information would be helpful.

JimN

>Can anyone give me some guidance on where to start looking for problems - I was thinking of a re-index!
>
>Thanks
>Kev