> When you start getting into that type of maintanence then maybe it is > simply easier to just do the two queries and then aggregate them using > QofQ =3F > If the DB supported full replication then you wouldn't even need that ;) > > The real solution - ulimately - is to get the data into a database system > that allows you to do the aggregates in the DB server.
Let's see if I've got this right. Get all data into a single Db - pretty clearly the best idea. Allows aggregation in the Db server - we're upgrading to MySQL, and my research indicates MySQl doesn't allow that (though I might be thinking of Views). > Gary Menzel > Web Development Manager > IT Operations Brisbane -+- ABN AMRO Morgans Limited --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
