Re: partiioning option not worth it?

Keith Boulton wrote:

>Fortunately for them, people generally assume that if
>it's done in the database (AQ, Replication, Partitioning Option) it is
>magically better than code that could be developed in-house.

Hi,

want to throw two aspects in

1. what about testing, bugfixing, becoming more robust and the maintainabiliy? Each time you implement partitioning on your own, you have to test it. Oracle's Partitioning is part of the database, so Oracle Corp does the testing for you. Every new release of you application has to be regression tested. Again and again. Whe you buils a further application which requieres hat functionality, you have to reimplement it again and again and again...
2. What about the difference between a declarative feature and a programmatic solution? You can declare constraints inside the database via a simple "ALTER TABLE blablabla" or you can bulletproof your code to avoid logical corruption of your data. What's cheaper?

just my 2 cents

regards
Marc Blum
mailto:marc_at_marcblum.de
http://www.marcblum.de Received on Sat Feb 23 2002 - 05:50:21 CST