Trigger vs web service - Mailing list pgsql-general

From Marc-André Goderre
Subject Trigger vs web service
Date
Msg-id F8CF7C70BB8C7441A2F81F655AF22DD7013B16C01EB2@facteur07.cegep-chicoutimi.qc.ca
Whole thread Raw
Responses Re: Trigger vs web service
List pgsql-general

I receive a long string (about 1 per second) than content many information and for the moment it is directly inserted in the database (1 column).

I have to treat the hole string every time i need information in it.

Now, I want split the sting and save the informations in differents fields.

I have 2 solutions and would like to have your opinion on them.

 

1- Program a trigger function detecting the orginal insert, split the string and fill the other field.

2- Program a web service for receiving the string, split it and insert the informations in the db.

 

Witch is the fastest one (in performance).

 

Thanks

 

Marc-Andre Goderre

TI Analyst

 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Merged Model for libpq
Next
From: John R Pierce
Date:
Subject: Re: Trigger vs web service