Results 1 to 40 of 52

Thread: [RESOLVED] How can we hold an array has 20 MILLION PARAMETERS in VB?

Hybrid View

  1. #1

    Thread Starter
    Addicted Member BlueRose's Avatar
    Join Date
    Jan 2002
    Location
    ISTANBUL
    Posts
    245

    Re: How can we hold an array has 20 MILLION PARAMETERS in VB?

    To LaVolpe

    i tried to write file but i takes very long time and allocates very very much place (250MB for 3% of calculation) for text file this means it is not useful for this purpose output of this text file like below
    Code:
    0.0028001110111966269477543538:0 1.3 -0.6 -3:0.000462837667985896
    0.0028001110111966269477543538:0 1.3 -0.6 -3:0.000331897303655402
    0.0028001110111966269477543538:0 1.3 -0.6 -3:0.000221273850109942
    0.0028001110111966269477543538:0 1.3 -0.6 -3:0.000149302133905207
    0.0028001110111966269477543538:0 1.3 -0.6 -3:0.000102348957119539
    0.0028001110111966269477543538:0 1.3 -0.6 -3:0.0000575684975376337
    0.0028001110111966269477543538:0 1.3 -0.6 -3:0.0000291431488864269
    0.0028001110111966269477543538:0 1.3 -0.6 -3:0.0000154164786133479
    0.0028001110111966269477543538:0 1.3 -0.6 -3:0.0000084739858499305
    0.0028001110111966269477543538:0 1.3 -0.6 -3:0.00000483242850838852
    0.0028001110111966269477543538:0 1.3 -0.6 -3:0.00000285118016152584
    0.0028001110111966269477543538:0 1.3 -0.6 -3:0.00000173468560369513
    0.0028001110111966269477543538:0 1.3 -0.6 -3:0.00000108878362399447
    maybe it must be written in binary to hold less space but also this will not be useful


    To szlamany

    you can be right also i was thought this dont know the way because i am not familiar changing array to function

    could you show an example or explain this property?

    it sounds good at first sight but need explain in detail for me
    Last edited by BlueRose; Dec 26th, 2007 at 01:10 PM.
    You can do while you think that you can do

    If you think my answer solve your question, please rate it.

  2. #2
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: How can we hold an array has 20 MILLION PARAMETERS in VB?

    You have several issues to overcome...

    First - you need to examine how you are going to do random access to a file. Using a sequential access text file is not going to work for you.

    Then you need to be able to convert a DOUBLE in memory to it's 8-byte string representation - as you want to store the 8 byte value - not some displayed values of a number.

    I've never done either of those two things with VB - but I'm sure it's possible.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width