Re: Playing with PostgreSQL and Access VBA

From: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Playing with PostgreSQL and Access VBA
Date: 2005-04-23 05:20:18
Message-ID: 4269DB12.6090102@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In a real application that uses a client/server type database you should
NEVER construct queries that return a million rows.
You have to keep in mind that each record has to be sent accross the
wire via TCP/IP and it is going to take a lot of time to bring back 1
million rows and I am sure your network admin would notice increased
network traffic.

In a real application you would use something like the Delphi Tdataset
based components which will only bring back the records that can be seen
on the screen, then when you scroll, it brings back more.

you can manually create something like this using Postgresql handy LIMIT
and OFFSET sql keywords in your query to build a paging system.

Access is actually a very poor choice for client/server application
development, like I said before, invest some time learning Delphi, it's
not difficult at all and you won't have these problems.
You can get a copy of Delphi 7 personal edition and you can use the zeos
components with it. http://www.zeoslib.net

Tony

> .
>
> When I had it loop and add 1000 rows, it was ok... When I told it to
> add a million rows.... then after 250,000 the Access application hung
> (but not the whole machine, and not the
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message William Yu 2005-04-23 07:23:35 Re: Postgresql Windows ODBC
Previous Message Typing80wpm 2005-04-23 00:29:25 Playing with PostgreSQL and Access VBA