ok, want build database customers has 4 columns , 7 billion rows. don't know if mysql can handle this. need guidance on how proceed (ofcourse hiring it.)
what want :
the first 2 columns keyword , count. count number , keyword string. queries can :
select keyword has word, not have, equals or/and has count more or less etc.
so searchable database. know full text words only. how make both columns searchable , fast. need thousands of keywords returned in query within few milliseconds google auto-suggest?
what have :
a powerful database - 32 gb ram, amd opteron 3365 2.30 ghz quad core (ht), 2 tb sata (i know need sdd in case if works good).
can work if 10,000 users querying database?
i have seen data in tab delimited text file. can lucene trick? have import txt in mysql , index it? else work better ?
let me know pls. if tell me company or here can me set up? it's startup backing no worries involved costs.
mysql won't do. spend lot of time (and possibly money) partitioned it's searchable.
lucene do. grab elasticsearch, set sharding , have result. have learn different query language (different sql), it's small cost having inverted indexes out of box.
Comments
Post a Comment