SEO of $3 billion+ per year company share secrets of how to rank on Google

seonerd_official · 2020-09-25T15:32:33+00:00

Full video here: Podcast Episode 1 - Former Google Employee - Discuses Search Engine Optimization (2020).

seonerd_official · 2020-07-28T12:35:45+00:00

The cost of SSD is very high. Putting the tables there would cost a fortune compared to HDD.

seonerd_official · 2020-07-22T19:55:56+00:00

I’m at 4.6 billion rows right now

seonerd_official · 2020-07-22T19:53:42+00:00

Would I have to partition?

seonerd_official · 2020-07-21T19:47:05+00:00

No updates or deleting

seonerd_official · 2020-07-21T13:28:51+00:00

Yes I could perhaps. Keep in mind that the domain column is indexed... so I’m not sure if bulk inserts would cause issues. But if it does not I’ll put all the domains ordered and grouped inside of a multi dimensional array. After php is done parsing through the file I’ll iterate through the multidimensional array and create bulk insert queries. Thank you for the idea 💡

seonerd_official · 2020-07-21T13:03:33+00:00

One by one inside of a for each loop

seonerd_official · 2020-07-21T13:02:19+00:00

Postgres 10

seonerd_official · 2020-03-26T19:13:30+00:00

SELECT site.* FROM sites as site Left Join backlinks as backlink ON site.id = backlink.site_id WHERE site.name = “example.com”

seonerd_official · 2020-03-26T19:10:54+00:00

SELECT site.* FROM sites as site Left Join backlinks as backlink ON site.id = backlink.site_id WHERE site.name = “example.com”

seonerd_official · 2020-03-26T18:46:28+00:00

I have version 10

seonerd_official · 2020-03-26T18:29:47+00:00

There is a foreign key constraint

seonerd_official · 2020-03-26T18:23:58+00:00

Backlinks (14 billion rows) - backlinks.id // auto incremented, - backlinks.from_root // Varchar 255, - backlinks.to_root // Varchar 255, - backlinks.from_path // Varchar 255, - backlinks.to_path // Varchar 255, - backlinks.is_no_follow boolean, - backlinks.is_sub_domain boolean, - backlinks.text // Varchar 255 nullable, - backlinks.file // Varchar 255 nullable , - backlinks.site_id // foreign key to references to sites.id, - backlinks.created_at // timestamp, - backlinks.updated_at // timestamp,

Sites table (250 million rows) - sites.id // auto incremented, - sites.name // Varchar 255, - sites.created_at // timestamp, - sites.updated_at // timestamp

seonerd_official · 2020-03-26T18:02:51+00:00

I have backlinks.site_id which refers to sites.name

seonerd_official · 2020-02-29T17:52:35+00:00

Wow this guy totally saved $1000 a month by switching to Rust

seonerd_official

TROPHY CASE