Because we provide an SEO product, we need to have multiple proxies and IPs. Because we have the expertise, we prefer to use our own and not shared proxies. But, with each Server Host, adding multiple IPs is different, and the instructions can be lacking. We bricked the machine more than once, trying to configure…

I created an index on one field, which the database was dumped for backup. The operation took 5 hours, which is odd for the amount of data (156 million rows) Queries not working as it should I ran the new code using the new index, and it seems very slow—doing a select on the index…

I wanted to create a web service that takes the text and summarizes it using machine learning. There are several API services on the market, but I wanted to see how easy (or hard) it is to create my own. Step 1 – Use an existing NLP package There’s no need to reinvent the wheel,…

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,…

SEO allows small business owners to build fast, functional, and user-friendly websites that rank higher in search engines, allowing them to attract more interested potential buyers to their pages and ultimately improve conversion rates. SEO also helps create brand recognition for your company when search engine people are more inclined to support a product that…

Do you want to skyrocket your rankings on Google? Outshine your competitors in your industry? Then doing content marketing that satisfies user intent is paramount. We cannot overemphasize how important it is to write content that answers the questions or satisfies the query intent that readers have. Over the years, Google has transformed its ranking…

People were fascinated with sex and sexuality from the birth of human civilization. The figurine of Ain Sakhri Lovers is a figurine of a couple engaged in sexual activity dating to 9000 BCE, and you may be wondering what it got to do with adult keyword research, don’t worry, it will be clear soon. In…

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…

For me, SEO is fascinating, and it’s trying to figure out Google (or other search engines) algorithm. You see a black box, and via the inputs and outputs, you try to figure out what’s going on inside that black box. For that you need tools, of course, we have our tool, but any tool has…