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 <jgo...@gmail.com> On Tue, Apr 5, 2011 at 09:16, Marc-André Goderre <magode...@cgq.qc.ca>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* <http://www.lastspam.com>. >