Search Postgresql Archives

Re: Trigger vs web service

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@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.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux