How to handle 1 GB database ? Export it to SQL?!

Discussion in 'Programming' started by redhits, Dec 28, 2008.

0
  1. #1
    hey guys, i am having a 1 GB plain-text type database! (CSV format) the database contains names,and i want to make it search able, so if somebody search bogdan , to also return bogdan21, or rbogdan_kamelia... any suggestion how to make it fast? should i export it to mysql , or what ?! it's a huge database...
     
    redhits, Dec 28, 2008 IP
  2. iam.xavier

    iam.xavier Well-Known Member

    Messages:
    521
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    125
    #2
    Better Idea is to import that CSV to MYSQL and run a query for the search result. Important 1 GB file into DB won't be a problem..
     
    iam.xavier, Dec 28, 2008 IP