Reputation
240
Top tag
Next privilege 250 Rep.
View close votes
Badges
1 2 13
Impact
~17k people reached

  • 0 posts edited
  • 0 helpful flags
  • 4 votes cast
Apr
6
comment Trying to optimize query for performance (MySQL)
Better but still around 180-200ms without the order by but if I add the order by, and order by a field on the Issues table, it still takes several seconds (and more times then not, I will have an order by).
Apr
6
comment Trying to optimize query for performance (MySQL)
yea, all the fields that I am joining on have indexes.
Apr
6
revised Trying to optimize query for performance (MySQL)
edited tags; edited title
Apr
6
asked Trying to optimize query for performance (MySQL)
Apr
1
comment Mysql int vs varchar as primary key (InnoDB Storage Engine?
@ypercube So I increase the data to 2 million and the select statement for the int FK get slower exponentially where the varchar foreign key remain pretty steady. A think that the varchar is worth the price in disk/memory requirements for the gain in select queries (which is going to be critical on this particular table and a few others).
Apr
1
asked Foreign key constraints with MySQL/InnoDB
Mar
31
revised Mysql int vs varchar as primary key (InnoDB Storage Engine?
added some tested
Mar
31
awarded  Editor
Mar
31
revised Mysql int vs varchar as primary key (InnoDB Storage Engine?
adding storage engine
Mar
31
asked Mysql int vs varchar as primary key (InnoDB Storage Engine?
Mar
29
awarded  Supporter
Mar
29
awarded  Scholar
Mar
29
accepted Storing Changes To Records
Mar
29
asked Have less tables with a lot of data or a number of tables with smaller amounts of data?
Mar
27
comment Storing Changes To Records
@Eric is will probably vary. some table might be large or update frequently while other are small and update infrequently.
Mar
27
asked Storing Changes To Records
Mar
27
awarded  Student
Mar
27
awarded  Autobiographer
Mar
20
asked Designing An ACL Based Permission System