Blog

I am fairly inexperienced with the ramifications of doing a single select where joining several tables and there are several one-to-many relationships while also running some built in mysql functions using column values between tables. The tables will be fairly large. 10,000 accounts, 70,0000 locations, 350,000 email_sequences. The select I am performing: (from Laravel queryRead more

I have the following table, company_likes: Table “public.company_likes” Column | Type | Modifiers ————+——————————–+———————— company_id | integer | not null user_id | integer | not null created_at | timestamp(0) without time zone | not null default now() Indexes: “company_likes_pkey” PRIMARY KEY, btree (company_id, user_id) Foreign-key constraints: “company_likes_company_id_foreign” FOREIGN KEY (company_id) REFERENCES companies(id) ON DELETE CASCADERead more