Andrew Smith wrote:
- C++ app reads data from proprietary system and writes it into temp
table in PostgreSQL
- ASP.NET web service reads data from temp table in PostgreSQL and
generates HTML
[snip]
This temp table will probably contain up to 1 records, each of
which could be changing
Hi all,
I'm working on a problem at the moment where I have some data that I
need to get from a proprietary system into a web page. I was thinking
of using PostgreSQL as a middle man to store the data. E.g
- C++ app reads data from proprietary system and writes it into temp
table in PostgreSQL
On Tue, Jun 23, 2009 at 10:12 PM, Andrew Smithlaconi...@gmail.com wrote:
This temp table will probably contain up to 1 records, each of
which could be changing every second (data is coming from a real-time
monitoring system). On top of this, I've then got the ASP.NET app
reading the
On Wed, Jun 24, 2009 at 12:48 AM, Scott Marlowescott.marl...@gmail.com wrote:
Maybe. Rows that are updated often are NOT generally pgsql's strong
suit, but IF you're running 8.3 or above, and IF you have a low enough
fill factor that there's empty space for the updates and IF the fields
you