Hello to all Programmer

i have a problem in ADO, every time i going to load the 200,000 record in Visual Basic it so very slow, its consuming a time for 1 Minute and 30 second, what are the solution for that? in Delphi 5 its only 3 Second and the database its already in DBGRID, please help about my problem.

ADO is supposed to be quick...

is your table indexed??? (I am assuming that you are aware of how to set a relationship with the database using ADO so i am not checking that....)

will be back from office in evening. will check your reply later :mrgreen:

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.