Devart Forums

i have 40 tables in a db (sql server 2000), all related. im using delphi 7 and sdac 3.00.0.2 . table sizes range from 50 to 150 fields, with table relations forming a tree, of up to six tables deep (ex. patient -> operation -> body part -> organ -> arthery -> arthery section). even in an empty db with only three records in the master table and all other table close to empty, i takes 16 seconds from the moment i click on a record to actualy scroll to it and update detail tables. can this be solved without breaking the master - detail chain, and no serious coding (i hope for a solution in a sdac component property)

At first, try to download SDAC 3.50.0.13. If it doesn't help, please prepare a small complete sample to demonstrate the problem and send it to SDAC support address - possible, we'll suggest ways to increase performance. Also include script to create and fill used tables.

PS: could it be that you use CursorType ctDefaultResultSet?

i do use defaultresultset. i don't know much about cursor types, is this the problem?

DefaultResultSet in your case is a right solution. If you send a small complete sample to mydac support address we could try to suggest something.