Skip to content

Instantly share code, notes, and snippets.

@si294r

si294r/tuneup_20161024.md

Created October 25, 2016 04:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save si294r/6ae78778d83d2d99a3475544f85dd7d7 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save si294r/6ae78778d83d2d99a3475544f85dd7d7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
tuneup_20161024.md

Hasil Eksperimen Tune Up Big Table Events_1377 - Redshift :

Setelah ditambahkan sortkey pada kolom event_time, ternyata hasil query tidak ada perubahan dan tidak menjadi lebih cepat

CREATE TABLE events_1377_2
(
   app_version  varchar(255),
   event_type   varchar(255),
   event_time   bigint,
   client_time  bigint,
   event_user   varchar(255),
   parameters   varchar(65535),
   payload      varchar(65535)
) 
compound sortkey(event_time)
;

Lama query untuk table events_1377 untuk sql dau fb = 49m 47s
Lama query untuk table events_1377_2 untuk sql dau fb = 49m 57s

Jumlah data yg dieksekusi = 1.039.001.810

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment