| From: | Marc-André Goderre <magoderre(at)cgq(dot)qc(dot)ca> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Trigger vs web service |
| Date: | 2011-04-04 15:47:44 |
| Message-ID: | F8CF7C70BB8C7441A2F81F655AF22DD7013B16C01EB2@facteur07.cegep-chicoutimi.qc.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2011-04-04 15:52:14 | Re: Merged Model for libpq |
| Previous Message | Adrian Klaver | 2011-04-04 15:08:45 | Re: Large Object permissions lost in transfer |