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
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
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
On 04/04/11 8:47 AM, Marc-André Goderre wrote:
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)
I receive a long string (about 1 per second) than content many information and
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
