Master/Detail with ADO and SQLServer 2000 ?
Posted on 2003-03-11
I'm just starting to develop a program with ADO and SQLServer 2000. I'm new with ADO and I need your advice. I run Delphi 6 professionnel on win2000 pro and MSQLServer 2000 on win2000 server.
My table structure is quite simple : I have 3 master table (policies, covers and clients).
1 policy can have 5 different clients (Assignee, recipient, club, owner, payer, etc)
1 policy can have unlimited covers and all covers can have 1 client (the insered).
My problem is when I put all these ADOtables in master/detail relationship, the application become very slow. With paradox, there is no problem, but I know that SQLServer does'nt like full table work. I know that I could use query with joins, but I have problem to display the information.
So, what choice do I have ?
BTW, I would like to buy some books on ADO and Delphi. Do you have any suggestion ??
Thanks in advance for your comment.