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@xxxxxxxxx>
--
Jorge Godoy <jgodoy@xxxxxxxxx>
On Tue, Apr 5, 2011 at 09:16, Marc-André Goderre <magoderre@xxxxxxxxx> wrote:
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.
