How big is too big for arrays?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: How big is too big for arrays?

  1. #1
    Join Date
    Jul 2009
    Posts
    4

    How big is too big for arrays?

    Hi there,

    I'm new to large databases.

    I would like to make a jagged array of size [50000][about 15][10]

    Is this too big? I also want to make an ArrayList that will have about 50000 values in it.

    Any advice appreciated

  2. #2
    Join Date
    Jul 2009
    Posts
    4
    If arrays and arraylists aren't suitable for storing this much data, any ideas on better ways? Hash tables maybe??

    Note: I've just worked out I would need to return to the database hundreds-of-millions of times if I worked with smaller arrays (I'm doing iterations with the data) so thats not really an option.

    Cheers

  3. #3
    Join Date
    Jul 2005
    Posts
    78
    Arrays and Arraylists use integer indices, so Integer.MAX_VALUE would be as big as you could make it.

    Of course, you're limited by available memory.

    Also, if you're doing database things, you should probably use a database.

  4. #4
    Join Date
    Jul 2009
    Posts
    4
    Thanks very much masher, this makes sense

  5. #5
    Join Date
    Dec 2004
    Location
    San Bernardino County, California
    Posts
    1,468
    Arrays/Lists are great for storing things while you are processing them but not great for search and retrieval. Hash tables, binary trees, maps, and other such structures are better for databases which implies (to me) that you want to search and retrieve more than process.

    If your needs are for many records and long term use with meaningful relational use, then MySQL and other database packages are easily incorporated into your project.

Similar Threads

  1. Joomla component to display XML/RSS feeds from Big Fish Games
    By Freelancer.Internet.com in forum Careers
    Replies: 0
    Last Post: 06-09-2009, 12:50 PM
  2. Mysql or PostgreSQL? Big tables
    By wakeup in forum Database
    Replies: 0
    Last Post: 05-23-2006, 05:33 AM
  3. MLM With A Big Difference - Rs. 60/- to join.
    By Shivani Arora in forum Careers
    Replies: 0
    Last Post: 06-04-2003, 11:43 PM
  4. Big consulting firms?
    By CProgrammer in forum Careers
    Replies: 2
    Last Post: 06-07-2001, 11:49 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center