We have an application which stores massive amount of urls. To save on indexes instead of using URL we index CRC32 of the URL which allows to find matching urls quickly. There is a bit of chance there would be some false positives but these are filtered out after reading the data so […]Read more
Recall that I’ve claimed that it takes 28 years to fill a disk with random insertions, given a set of reasonable assumptions. Recall what they are:
We are focusing on the storage engine (a la MySQL) level, and we are looking at a database on a single disk — the one we are using […]
On his way to MySQL Users Conference Andrew will stop by in Moscow, Russia and give a talk about Sphinx current features, development plans, and deployment use cases.
Interesting enough the meeting will take place at Moscow State University, Computer Science Faculty – my “Alma Mater” in the same building and even same room which […]
Today a customer asked me to help them to convert their sequence generation process to the stored procedure and even though I have already seen it somewhere I did not find it with two minutes of googling so I wrote a simple one myself and posting it here for public benefit or my later […]Read more