developmentseed / tipgstac

[DEMO] TiPG + PgSTAC
MIT License
6 stars 2 forks source link

Performance benchmark #7

Open vincentsarago opened 9 months ago

vincentsarago commented 9 months ago

it would be interesting to see if there are any performance differences between stac-fastapi and tipgstac

vincentsarago commented 8 months ago

First numbers without context 😅

------------------------------- benchmark 'collection': 2 tests --------------------------------
Name (time in ms)         Min                Max               Mean             Median          
------------------------------------------------------------------------------------------------
stac_fastapi          28.1290 (1.0)      43.0255 (1.0)      31.3058 (1.0)      29.3611 (1.0)    
tipgstac              28.9218 (1.03)     43.6818 (1.02)     31.6978 (1.01)     30.4099 (1.04)   
------------------------------------------------------------------------------------------------

------------------------------- benchmark 'collections': 2 tests -------------------------------
Name (time in ms)         Min                Max               Mean             Median          
------------------------------------------------------------------------------------------------
stac_fastapi          28.6338 (1.0)      39.8549 (1.0)      30.3666 (1.0)      29.8139 (1.0)    
tipgstac              35.3546 (1.23)     47.0559 (1.18)     36.9168 (1.22)     36.0285 (1.21)   
------------------------------------------------------------------------------------------------

---------------------------------- benchmark 'item': 2 tests -----------------------------------
Name (time in ms)         Min                Max               Mean             Median          
------------------------------------------------------------------------------------------------
tipgstac              60.3340 (1.0)      89.7602 (1.05)     65.8596 (1.0)      62.3305 (1.0)    
stac_fastapi          66.2748 (1.10)     85.1172 (1.0)      70.5391 (1.07)     69.2387 (1.11)   
------------------------------------------------------------------------------------------------

------------------------------------ benchmark 'items': 2 tests ------------------------------------
Name (time in ms)          Min                 Max                Mean              Median          
----------------------------------------------------------------------------------------------------
stac_fastapi          142.5853 (1.0)      156.5088 (1.0)      149.4787 (1.01)     150.0467 (1.02)   
tipgstac              145.2028 (1.02)     157.8110 (1.01)     148.2355 (1.0)      146.4914 (1.0)    
----------------------------------------------------------------------------------------------------

------------------------------ benchmark 'items_limit=1': 2 tests ------------------------------
Name (time in ms)         Min                Max               Mean             Median          
------------------------------------------------------------------------------------------------
stac_fastapi          73.3358 (1.0)      95.6097 (1.03)     79.4985 (1.0)      77.0270 (1.0)    
tipgstac              76.4258 (1.04)     93.0704 (1.0)      80.7718 (1.02)     79.7314 (1.04)   
------------------------------------------------------------------------------------------------