On Thu, 27 Jan 2000, Khimenko Victor wrote:
> Ext2 is not relevant here. Since VFS in 2.2.x does not support files with
> more then 2GiB size you can not have such files with ANY filesystem.
>
> > So, to accomplish the task I must use more tables with maximum size of
> > 2GB.
>
> Exactly. Each table should be under 2GiB in size but full database can be much
> bigger. About mysql/postgresql... MySQL is VERY fast on small and medium sized
> databases but it's not very suited to handle REALLY large ones: I've seen
> big performance drop after 500'000-1'000'000 records in table (sometimes even
> 100'000 was enough). Not know about postgresql...
Are you confusing MySQL with msql? With larger tables
optimizing you indexes is important, but I have used MySQL wel beyond
the 500,000-1,000,000 mark (8 - 10 million rows is about normal
for most of our logging and capture systems).
--- As folks might have suspected, not much survives except roaches, and they don't carry large enough packets fast enough... --About the Internet and nuclear war.- To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to majordomo@vger.rutgers.edu Please read the FAQ at http://www.tux.org/lkml/
This archive was generated by hypermail 2b29 : Mon Jan 31 2000 - 21:00:24 EST