hmm if you were running PostGreSQL ;p I'd suggest using a trigger on insert or a scheduled stored proc - but if you want it updated regularly you might be best to create a scheduled task that does what you're describing - select from each table and insert into the new one.
Friday, February 7, 2003, 11:52:22 AM, you wrote: MS> Hi All MS> I've got a little problem I'm toying with and was just wondering if you have MS> any thoughts. I've got a hit counter thingo that I've knocked up with CF and MS> MySQL. We run it on a few of our sites. One of the *features* of it is you MS> have a table of IP (two cols, a unique id and an ip field) that you MS> generally don't want included in statistical output. This is for blocking MS> spiders, etc.. Each site has its own exclusion table in its own datasource. MS> What I want to do is regularly merge all of these tables and am a bit MS> stumped as to how to do this. Ideally I would want a master table that all MS> of the stats collectors & reports use, but I need the one in each datasource MS> for querying purposes. MS> What I have thought of so far is that I set one table as the master, do MS> periodic checks on what IPs have been added to the slave tables and add MS> these to the master. Then drop all the slave tables and recreate them MS> mirroring the master table. This seems kind of overkill. Is there an easier MS> or more efficient way? MS> Cheers MS> Mark MS> ______________ MS> Mark Stanton MS> Web Production MS> Gruden Pty Ltd MS> Tel: 9956 6388 MS> Mob: 0410 458 201 MS> Fax: 9956 8433 MS> www.gruden.com MS> --- MS> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] MS> To unsubscribe send a blank email to [EMAIL PROTECTED] MS> MX Downunder AsiaPac DevCon - http://mxdu.com/ --------------------------------------- Life is poetry - write it in your own words. --------------------------------------- Toby Tremayne Technical Team Lead Code Poet and Zen Master of the Heavy Sleep Toll Solutions 154 Moray St Sth Melbourne VIC 3205 +61 3 9697 2317 0416 048 090 ICQ: 13107913 --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
