Re: very large databases

On 28 Apr 2007 10:10:21 -0700, byaarov@xxxxxxxxx wrote:

Hi... we are considering storing images in our database and the number
of images can be quite large...

So the other option is to store the images as files and point to them
from the DB...

To make this decision, i'd like to know what the maximum sizes of
databases are... Can Databses become more than a TB in size?

B


Others have posted the fact that most commercial and/or
production-ready open source db's are capable of growing without
bound.

However, managing that db and keeping it trim and fast is much more
difficult.

How will you purge data? How long will you keep images in the db?
How long can you wait for a query to be satisfied?

~F
.

Relevant Pages

  • Re: Simple DBMS in VB
    ... Because you want to store variable length data, ... but complicates updating when changes in the data necessitate ... seem the Genre table and the Album's song lists would not need updating ... is to keep the images in their ...
    (microsoft.public.vb.general.discussion)
  • Re: Simple DBMS in VB
    ... Because you want to store variable length data, ... but complicates updating when changes in the data necessitate ... seem the Genre table and the Album's song lists would not need updating ... is to keep the images in their ...
    (microsoft.public.vb.general.discussion)
  • Re: storing path only to database
    ... Do not store the images in the file, rather store them on the hard drive and ... store the path to them in the Access database. ... Alternatively, you can store images in multiple tables, each one of which is ... Dim MyFolder As String ...
    (microsoft.public.access.formscoding)
  • Re: Architecture question
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... The fax machine would store incoming images in a windows folder. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Simple printing and graphics
    ... images; you store the data that defines what the images are to be drawn. ... not sure you're talking about images or the Graphics class. ... wrap the .Net printing method into a simpler class. ...
    (microsoft.public.dotnet.languages.csharp)