On Wednesday 31 May 2006 02:29, Brendan Duddridge wrote: > We'll probably have to write a process to update the click_count from > querying our product_click_history table.
How about an insert trigger on product_click_history which updates click_count every say 10000 transactions or so? jan -- -------------------------------------------------------------- Jan de Visser [EMAIL PROTECTED] Baruk Khazad! Khazad ai-menu! -------------------------------------------------------------- ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq