215 reputation
210
bio website ryanzec.com
location Massachusetts
age 29
visits member for 2 years, 6 months
seen Mar 27 at 16:18

A web developer focusing in PHP/MySQL and an inspiring game developer using the Unity game engine.


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