Trigger vs web service
I receive a long string (about 1 per second) than content many information. 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
--
Ce message a été vérifié par le service de sécurité pour courriels LastSpam<http://www.lastspam.com>.
If I was Yoda, I would say "The answer you seek is... it depends"
If I were you, I would test both solutions and check which one performs
better and impacts the least on your environment.
For example, if you have no logic at all on the database then I would code
that in the frontend. If you have code in the database, then checking how
this specific function works there would also be worth a shot.
--
Jorge Godoy <jgodoy@gmail.com>
On Tue, Apr 5, 2011 at 09:16, Marc-André Goderre <magoderre@cgq.qc.ca>wrote:
Show quoted text
I receive a long string (about 1 per second) than content many information.
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
--
Ce message a été vérifié par le service de sécurité pour courriels *
LastSpam* <http://www.lastspam.com>.