Jeff Johnson wrote: > I have some very large tables that are processed over a network. I > would like to split them into monthly tables - one table per month. > When I print reports I want to combine the months covering the data > range selected by the user. > > Has anyone built an application using this technique?
Why split 'em when they belong all together? If you are running into the 2GB limit or suffering from index suck, the proper thing to do IMO would be to upsize to a database server like PostgreSQL or MySQL, or if you want to pay for it, Oracle or MS-SQL server. Just my 2 cents. Paul _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
