This is the second article in the MySQL optimization series. In this article, I’m going to cover how to speed up select speed , improve query performance and improve MySQL performance. Some of the concepts here will be similar to the ones in the previous article, so we will summarize them and not go over…

The heart of our SEO Analytics product is a fast insert performance custom database. In this blog post, we cover the reasons why we developed a custom database. In summary, MySQL/PostgreSQL insert performance degrades after 50-100GB of data from 14,000 inserts per second to 3,000 inserts per second. This limitation forces the utilization of clusters,…

PHP was invented in 1994 for web applications, it’s very similar to C and C++, and it’s ranked #7 as in popularity of development language. It is used by sites such as Facebook, Slack and us, of course. Since it’s similar to C/C++, it was easy to learn and use. We have an SEO API…

If you’re following my blog posts, you read that I had to develop my own database because MySQL insert speed was deteriorating over the 50GB mark. That’s why I tried to optimize for faster insert rate. The application was inserting at a rate of 50,000 concurrent inserts per second, but it grew worse,  the speed…

What is PageRank? Hello, everyone. This is Barak from SEO Explorer. And this is the fourth podcast. Today I’m going to speak about PageRank. What is PageRank? How does PageRank affect outgoing links, incoming links, where this came form and in today’s podcast, I’m doing something new. My SEO Experiment Before I came to speak,…

Hello, everyone. This is Barak from SEO Explorer. And today I’m going to speak about web hosting. Now, when I’m talking about web hosting I’m not talking about web hosting for websites specifically, although I’m going to touch that subject. Cost of Amazon’s AWS I’ve been talking to a lot of people about hosting when…

Having any type of digital product is great, you can sell it. Usually, there are no costs associated with delivery, no production costs, and no warehouse. Implementing your own idea, SEO or otherwise is a process that has many hardships, but can have immense satisfaction. If you reached this page I assume you know what…

I’m training the GPT2 1558M model with 2,300,000 tokens, I rented a server from Hetzner that has 12 threads and 256 GB. Before playing with batch number, each step took 90 seconds, I reached step 1400, and the average loss didn’t drop below 2.3, since I’m using a CPU and not a GPU (memory usage…

If you know a thing or two about databases, the mere thought of writing a database should set off alarm bells, and if you had asked me 3 years ago I would have probably told you to drop it – why write a database? With so many good free open source databases on the market,…