Oracle, faster search than P4?

[Etdashou]

HI all,

small question here for anyone who is using SC6.x or SC7.x with Oracle database.

Is the search faster with Oracle db than P4 db?
If yes, a lot more faster or a small upgrade?

Thank you to write any info!

[tommy]

First. SM7 do not support P4 so the question is not relevant there.

Second. Which is fastest depends on size of database. Small databases P4 is probably fastest.

[Etdashou]

kk,

Thanks for the answer.

all I want is feedback from users that did the upgrade.

Thanks to anyone that can share their experience with database change (P4 to Oracle).

[jstagaman]

Look, there is not a consistent answer. Users who had a well-tuned/indexed P4 database may have seen little or no improvement, and may have actually encountered a decline in speed of response, until they tweaked their indexes for Oracle. I encountered am SC6,2 system on Oracle with 600+ inboxes, none of which was even partially keyed, so they were all using full table scans on the Oracle backend--it was tremendously slow. But since the indexes/keys weren't relevant to their data, P4 would have been slow too.

If both P4 and Oracle are properly indexed and configured, you probably won't see a noticable query response improvement. But you have the opporunity to use Oracle reporting to improve indexes and query response times, so you may be able to better tune your Oracle back-end then you were able to do for P4.

[benvargas]

Not to mention the added capabilities to backup utilizing Oracle alone (no more worrying about P4 and "hot backups")... not to mention the ability to replicate to a reporting database utilizing the RDBMS tools so that reports are not running on production databases to begin with.

Bottom line, there is maintenance to be done if you're using SC6.x P4 keys or indexes in Oracle/DB2/SQL... it's not so much a P4 vs RDBMS debate, but more a competent administrator in terms of maintaining the database. Sure, smaller databases keyed properly in P4 were faster, but when you're talking about a larger organization with exponentially more records, a properly indexed external vendor's RDBMS is better (and you also get the RDBMS specific tools).