cmc-csci143 icon indicating copy to clipboard operation
cmc-csci143 copied to clipboard

Too fast ?

Open JWise16 opened this issue 7 months ago • 2 comments

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 ?

JWise16 avatar May 07 '25 21:05 JWise16

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 :)

mikeizbicki avatar May 08 '25 04:05 mikeizbicki

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?

JWise16 avatar May 08 '25 05:05 JWise16