Well, at last I decided to create my own design for that site. And I’ve done this within couple days. The main idea of the site is to create database of soon expiring domains. In general, I wanted to make advanced MySQL tests and procedures with larger databases, over several million records. For the website it is quite big database, but in with experience I could say it is also a small database. After exploring lots of various scripts, I noticed that all of them are not designed to work with large databases.  I even don’t talk about full table scans – they are usually made without any need of doing that. I agree that using LIMIT is the fastest and simplest way to use database row selection, but this is one of the worst decisions. Imagine, if you have a table with 10,000,000 records, and want to select 20 records. I could bet you will use LIMIT. But I wouldn’t use that. I don’t need to scan entire table.

That’s why I’ve created this site. The main purpose for myself if advanced mysql plays. After right indexing, mysql speed improved around 9,5 times! The tests were made with 500,000 records.

Well, the site is still in beta. I just wanted to show a design I can currently create I think it is not a bad beginning for a programmer