Difference: TAPVizieRLoadTest (2 vs. 3)

Revision 32016-04-06 - ThomasBoch

 
META TOPICPARENT name="NotesGaiaDR1"

Méthodologie

Tests faits sur IGSL (taille comparable avec Gaia)

5 requêtes type :

  • R1: SELECT sourceId, RAJ2000, DEJ2000, magBJ, e_magBJ FROM "I/324/igsl3" WHERE magBJ<14
    --> retourne 10.3M tuples
  • R2: SELECT sourceId, RAJ2000, DEJ2000, magRF, e_magRF FROM "I/324/igsl3" WHERE magRF<14
  • R3: SELECT sourceId, RAJ2000, DEJ2000, magG, e_magG FROM "I/324/igsl3" WHERE magG<14
  • R4: SELECT sourceId, RAJ2000, DEJ2000, magGrvs, e_magGrvs FROM "I/324/igsl3" WHERE magGrvs<14
  • R5: SELECT sourceId, RAJ2000, DEJ2000, pmRA, pmDE FROM "I/324/igsl3" WHERE SQRT(pmRA*pmRA + pmDE*pmDE)>100
    --> retourne 85M tuples
On boucle sur ces 5 requêtes (eg: si 10 requêtes concurrentes, chaque requête type est exécuté 2 fois)

1 requête concurrente

Durée :

  • R1 : 1611s

5 requêtes concurrentes

Durée :

  • R1 : 1619s
  • R2 : 1637s
  • R3 : 1673s
  • R4 : 1673s
  • R5 : 2725s

10 requêtes concurrentes

Durée :

  • R1_1 : 1656s
  • R2_1 : 1680s
  • R3_1 : 1817s
  • R4_1 : 1820s
  • R5_1 : 3171s
  • R1_2 : 1651s
  • R2_2 : 1676s
  • R3_2 : 1832s
  • R4_2 : 1822s
  • R5_2 : 3171s
Changed:
<
<
-- ThomasBoch - 2016-04-05
>
>

20 requêtes concurrentes

 
Added:
>
>
Service rendu indisponible plusieurs minutes ...

-- ThomasBoch - 2016-04-05

 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback