James McDonald

Access

Blog History

Automate Chrome with Puppeteer

https://github.com/puppeteer/puppeteer Every now and again I need to connect to a website and then scrape something so I don't have to do a couple of hundred repetitive actions Enter Puppeteer You can basically get Chrome to do whatever you want using puppeteer and...

read more

Use FORCE INDEX

Just putting this here as I have a SELECT in MySQL that was taking 1.946 sec to return 20 records from a table with 159884 records when using a ORDER BY DESC on a DATETIME field Creating an index and changing the FROM to FORCE INDEX () dropped it down to 0.00079 sec /...

read more