cmc-csci143
cmc-csci143 copied to clipboard
Too fast ?
Hi Mike - I got so much speed up in pg_normalized_batch that I am now worried that I did it incorrectly
(venv) lambda-server:~/bigdata/twitter_postgres_indexes (master *%=) $ cat results.normalized_batch
sql.normalized_batch/01.sql pass
sql.normalized_batch/02.sql pass
sql.normalized_batch/03.sql pass
sql.normalized_batch/04.sql pass
sql.normalized_batch/05.sql pass
real 0m0.759s
user 0m0.078s
sys 0m0.043s
is <1 second alarming ?
The queries themselves should take milliseconds with good indexing, and the rest of the time is overhead from the shell. <1 second is on the fast side, but still perfectly possible. So I don't think there's an issue and this looks like full credit :)
Sweet ! I think that should pull me back up to a B-
I have pushed the results and schema file ~ if this does in fact get me back up, can we call it there?