Join GitHub today
GitHub is home to over 20 million developers working together to host and review code, manage projects, and build software together.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
|Failed to load latest commit information.|
This is a litle experiment to try to do a php wrapper to use MySql with huge database tables (logs, etc), and search into it, not using any external software like: memcached, mongoDb, etc. The trick is to create a table MyIsam, with a fulltext search index (OMG!) and a uuid with primary key index. We use this table as key:value table, but in addition we created a fulltext index to datapack row values (serialized) Interesting ... fulltext MyIsam capability can find text into serialized fields. Benchmarks said we found needle in haystack in 0.003~0.004 secs against 1 Million records. So... MyIsam is not bad at all! ;-D