Sometimes, the easiest way to do this is to use the file system of the linux
machine to store the files, and make reference to them in the DB...storing
not data in the DB and getting rid of all your possible problems.
Thanks,
Matt Babineau
Criticalcode
858.733.0160
[EMAIL PROTECTED]
Cabbar Duzayak wrote:
So my questions are:
1. The main question is, do you guys have any experience with this
much binary and regular data? Do you think Mysql can handle this much
data in a reliable manner (without corrupting data and/or
degrading/terrible performance) ?
I would say so,
First of all, I heard that Mysql does not perform very well when
tablesize goes above 1 Gb. Is this a myth?
I don't have much experience with individual tables being that large,
though I have used MySQL databases with 100G total data with no
problems at all. Based on my experience, it's not
Per Jessen wrote:
3. Again, as you can understand, I want to minimize the cost here. If
you don't think I can use mysql, do you think Microsoft SQL server is
good enough for this task?
I don't think so, no.
what are you basing this on?
SQL Server is a truly great database package, don't