>Won Lee wrote:
> > I asked the question because I didn't know if one would be more
> > beneficial then the other. No speed bonus? Speed bonus would make it
> > worthwhile for me.
>
>To increase speed the relevant setup steps would be:
>- get enough RAM so the 300 MB table is fully cached
>- split logs off from data storage to a different physical storage
>- split schemas over tablespaces on different physical storages
>
>
>The results you can get from this are probably dwarfed by the performance
>increase you get from smart indexing.
>
>Jochem
Thanks. I will keep that in mind. The SQL Server implemented is the MS
version. I'm not sure but i think, Schema in the Oracle world is actually
the same as Databases in the MS world. The term DB and SQL Server Group is
probably the match between the Oracle and MS world. Someone please correct
me if I'm wrong. Either way, I had a chance to use MySQL, but not Oracle,
and chose MS SQL server because a) we had an unused license and b) I got
all the data in excel format and just found it easier to create DTS
packages to import the data. I haven't used Oracle in about 4 years which
is a shame because I always felt it was the best. I've decided to just
create one database and try to performance toon it with good indexes. I'm
also going to batch process some of the data that takes awhile to get and
store it in a cursor for daily usage.
I can, and will be, getting more memory for the machine.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
