Changeset - a3bc9e0f40b2
[Not reviewed]
default
0 1 0
Laman - 7 years ago 2018-04-01 14:03:36

optimalizace: zapomenuté indexy na cizích klíčích v databázi
1 file changed with 2 insertions and 0 deletions:
egd.py
2
0 comments (0 inline, 0 general)
egd.py
Show inline comments
 
@@ -68,6 +68,8 @@ def setupDB():
 
				from players_performance as pp join tournaments as ts on pp.tournament_code=ts.code
 
	""")
 

	
 
	cursor.execute("""create index pp_pin on players_performance (pin)""")
 
	cursor.execute("""create index pp_tournament_code on players_performance (tournament_code)""")
 
	cursor.execute("""create index pp_country_ind on players_performance (country_code)""")
 
	cursor.execute("""create index t_datum_ind on tournaments (datum)""")
 

	
0 comments (0 inline, 0 general)