SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-18-2008, 12:37 PM
| ||||
| ||||
 Best way to check for new data. I have a table that holds entries as in a ficticious table Log(id integer, msg text). Lets say then that I have the program log_tail that has as itīs sole purpose to print newly added data elements. What is the best solution in terms of performace? Thank you for your time, Rodrigo      |
|
04-18-2008, 12:37 PM
| ||||
| ||||
| Re: Best way to check for new data. Rodrigo, You could use LISTEN + NOTIFY with triggers. In after_insert_statement trigger you could notify a listener, the client could query it immediately. Best Regards, Otto ----- Original Message ----- From: Rodrigo Madera To: pgsql-performance@postgresql.org Sent: Friday, October 28, 2005 11:39 PM Subject: [PERFORM] Best way to check for new data. I have a table that holds entries as in a ficticious table Log(id integer, msg text). Lets say then that I have the program log_tail that has as itīs sole purpose to print newly added data elements. What is the best solution in terms of performace? Thank you for your time, Rodrigo |
Linear Mode
