This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes Database Size Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Database Size" Watch "Database Size" New topic
Author

Database Size

B Power
Greenhorn

Joined: Jun 22, 2004
Posts: 5
I know this doesn't really have anything to do with java but I really would appreciate help with this.

I'm planning a database which will at most have 1000 records with 20 fields, my estimations for its size are, well, tiny (i.e. few megabyte range at most).

Am I right? I've never had to estimate database size before... (small-time, I know...)

I have to make a request for application hosting and for something so small they are making me jump through too many hoops.
Blake Minghelli
Ranch Hand

Joined: Sep 13, 2002
Posts: 331
Well, you could get more precise by calculating the max row size and then multiplying that by the estimated number of rows.
For example, just to make things easy, let's say you have one table with 3 columns:
1. Integer (4-bytes)
2. varchar(6) (6-bytes)
3. varchar(10) (10-bytes)
Total row size = 20b
Total table size = 20b * 1000 rows = 20,000b = 19.5kb

Of course that's just data storage size.


Blake Minghelli<br />SCWCD<br /> <br />"I'd put a quote here but I'm a non-conformist"
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Database Size
 
Similar Threads
Signed Applet - Problem reading large local files
triangle algorithm
why do code tags miniaturize the code?
Optimize Oracle Performance?
html:select