Opened 11 years ago

Closed 9 years ago

Last modified 7 years ago

#308 closed improve feature (wontfix)

Add IdCountry to members table

Reported by: jaliste Owned by:
Priority: minor Milestone: Legacy Resolved
Component: BW General Keywords: db, performance


Hi, there are some querys in rox app to look for count of pending users. This query does a join to the cities table and then to the countrys table only to check for the accepterscope. The two joins can be avoided by adding the redundant idCountry from the address to the members table.

Change History (5)

comment:1 Changed 11 years ago by feuerdaemon

  • freq_reported set to 1
  • Milestone changed from unassigned to BigPicture
  • show_on_bw set to 0

comment:2 Changed 11 years ago by philipp

  • Milestone changed from BigPicture to unassigned

Milestone BigPicture? deleted

comment:3 Changed 9 years ago by fake51

True, we can add data redundancy, but that's a very bad idea unless we're experiencing load problems. I'm marking this wontfix, as it's not a problem we're experiencing and it's doubtful that it ever will be

comment:4 Changed 9 years ago by fake51

  • Resolution set to wontfix
  • Status changed from new to closed

comment:5 Changed 7 years ago by TimLoal

  • Milestone changed from unassigned to Legacy Resolved
Note: See TracTickets for help on using tickets.