I have a solution, all in one database.
In the database there is a table, where you can put pictures in a field.
Is it wise, to make an other(seperated) database, (in my case Firebird) where the images land in? Because this database can rapidly grow.
in other words: does the size of the database effects the performance of the rest of the data?
Are there whitepapers about such an issue?
Do I make any sense?
As I understand it the size of the data source always affects performance.
In general, the larger the data source, the longer it takes to retrieve the query results. For relational databases, indexing substantially improves performance, particularly for large databases. However unlike other products, images are stored withing the database as BLOBS (binary large objects) and SQL databases tend to be more experienced at handling large amounts of data.
HTH
Yeah oke,
but is it wise to seperate the image-database from the normal text-database?
Or is it not necesary?
Not an expert here, but from what I know of SQL databases:
Performance is table related. One very big table in your DB does not affect the performance of other smaller tables.
Also, the performance of a table is not so much related to the number of columns and the content of the field as it is related to the number of records and the way you look for data in the table
Searching on indexed columns is xxx times faster than on non-indexed columns.
The size of the contents of Blob fields is not affecting the performance (maybe just retrieving the content of the blob once it is found by the DB might take a bit longer…)
If you do LIKE searches, I think any indexes are useless and it comes down to how many records are in the table (This one I’m not 100% sure about)
I know that Oracle gives you options to partition a table. This means you have one table, which consists of many small tables. your application sees it as one table. If you specify which partition your data is in, the DB doesn’t have to go through all the data in the total table, but just has to go thorugh the partition (Partitioning can be, for example, by month)
just my 50 cents…
Paul