January 25, 2013 at 6:46 am
I know how to estimate the size of a table (number of bytes stored per row X number of estimated rows) so can estimate the size of a database.
Possibly naive question - how do do you perform as similar estimate when BLOBs (stored in table - not linked) are involved?
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
January 25, 2013 at 9:32 am
Only way I'd know is to estimate your average BLOB size.
Or for safety, find the maximum likely size and use that.
(Sorry if they're obvious suggestions).
January 28, 2013 at 12:53 am
Hi Gaz,
Thanks for that - I was going to work on max size X number of entries anyway - unless anyone came up with anything more scientific.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply