DBGrid with a lot of Records....Performance issue

[ZarrinPour]

Hi
As i said earlier i'm using ADODataset with SqlServer 2000
As you know REQUERY() function will refresh all records in adataset BUT i need somehow to refresh only one record of dataset .... is there any trick??? using REQUERY or (Close/Open) takes a lot of time to populate recors in the DBGrid.

AnyWay...Thanks all of you for following my problem. :-)
Regards.

[i4get2]

If this hasnt been answered Ill throw in my 2 cents. First are you setting Indexes on the SQL server? Are you also setting the cursor to use the server? These things help speedup all the searches and refreshes.

[ZarrinPour]

Hi i4Get2
Thanks for ur help
You said
First are you setting Indexes on the SQL server?
Are you also setting the cursor to use the server?

If you don't mind could you please point me on a right direction on how could i do or check these settings(Index/Cursor) in sqlserver2000?

I Appreciate your help.
Kind Regards.

[Jasser]

Why don't edit the record in the query and post it back to the query so you don't have to refresh the query? Check my first post to you in this thread.

Regards,
Abdulaziz Jasser

[i4get2]

Sorry just now getting back to you. I asked these questions when I was at work. Yes on SQL server if you open the enterprise manager and go to the database then to the table that you are running the query on right click on the table then choose design table. generally you will want to make a index on the primary key and then the field you are running your query on. you can do this by choosing the manage indexes from the toolbar at the top.Now for the cursor location. In delphi if you click on the Adoquery1 then in your object inspector choose the cursorlocation to use clUseServer. Now make sure your table is using the same datasource that you are running the query on. Also instead of doing a refresh if you do the edit with the query you will not need to refreash the whole table. I would also recomend that you only select like top 200 records on the first initial query for the table so you are not loading the whole table records in the grid.