I have simple URL shortener (PHP) where I’m tracking clicks. Every click is saved to database (mysql currently) as separate row because I need also info about device, country etc. It works great but when table grows and grows queries becomes slow, so I want to migrate to BigQuery (I know they are different in many ways but I think
Tag: bigdata
PHP dynamical value as time() function speed in bigdata
What is the preferred (less memory consuming and fastest) approach to use time() or any similar dynamic value in billion+ iterations? A) B) C) I would personally prefer C) but I don’t know how will PHP use memory, if every iteration is storing time as variable? Is it the same in A) and B)? Answer A is surely the fastest,