Search Postgresql Archives

Re: Trigger vs web service

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

 



 

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

 


[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