--- In [email protected], siva subramanian <[EMAIL PROTECTED]> wrote: > > Dear All, > I have one Delphi 7 application software.In that software i am using backend for PostgreSQL 8.1 with linux server fedura version.I am using this software through internet.After getting more data in PostgreSQL database server will be slow.In delphi 7 i am using data access component Zeos Lib.I cann't fund where is the problem.Please advice where is the problem.Advance thanks to all. > Kindly Regards > Siva > > ---------------------------------
Hi Siva, Optimise your database with indices and links. Then make your queries more efficient. Since you are receiving over a slow link only load the items that have been added or changed. Mick
