Managing and searching matrix with databases

Discussion in 'PHP' started by ankit_frenz, Nov 27, 2009.

Thread Status:
Not open for further replies.
  1. #1
    Hi,
    What i want implemented is storing matrices in sql.
    The size of matrix is huge around 300*300.
    There are around a million of such matrices to be stored.
    I need to make searches in this matrices.

    So that basically means
    i cant use serialize() since i have to make comparison and searches.
    i cannot store each node of the matrix separately since that will result in
    300*300*1000000 records which is impractical.
    Moreover i want to make it as fast as possible obviously.

    I have been digging search engines but i don't see any thing that can handle this stuff.
    Any Response will be appreciated.
    Thanks
     
    Last edited: Nov 27, 2009
    ankit_frenz, Nov 27, 2009 IP
  2. kbduvall

    kbduvall Peon

    Messages:
    71
    Likes Received:
    3
    Best Answers:
    4
    Trophy Points:
    0
    #2
    This is more a databse question. You may want to post it in one of the database forums. Not only is it the correct place, but you'll find more database experts there. You'll find more coders here than DBAs.
     
    kbduvall, Nov 27, 2009 IP
Thread Status:
Not open for further replies.