Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Partitions for relatively small tables
Hi,
I currently have 14 tables each should populate with 5000 rows in a
half an hour and this is only now...
This is a real performance issue and I want to squeeze the best out of
my system which (you guest it) isn't that new nor fast.
Will partitioning will gain me performance?
Is there are reasons why I shouldn't use them on relatively small
tables?
As I asked before I also referring to working with the table after the
load issues like performing selects and removing data...
Thanks,
Viktor
> pagesflames_at_usa.net (Dusan Bolek) wrote in message
> news:<1e8276d6.0306270026.6a6ddaef_at_posting.google.com>...
> If I understand you correctly, you are inserting 5000 rows each half
> hour and want to keep them for two weeks. You're asking if you should
> put each 5000 in its own partition. Answer is NO. I think that you
> should use simply inserts. You probably wouldn't get any performance
> gains with 5000 rows in partition.
> Also I can't understand your performance issues, on any decent system
> you must be able load 5000 rows in no time and your system seems to me
> like very low loaded one. Have you encountered any real performance
> issue or you're just trying to improve just for improvement?
Received on Sun Jun 29 2003 - 04:27:31 CDT