Tagged Questions
2
votes
1answer
418 views
PostgreSQL versus MySQL for EAV structures storage
Is there any practical difference or what are the advantages of using Postgres 9.x versus MySQL 5.x for storing EAV (Entity-Attribute-Value) structures, especially in terms of read performance?
2
votes
1answer
362 views
Do I have duplicate key indexes?
CREATE TABLE relations (
object_id BIGINT(20) NOT NULL PRIMARY KEY,
object_term BIGINT(20) NOT NULL,
UNIQUE KEY link(object_id, object_term),
CONSTRAINT fk_term FOREIGN KEY(object_term)
...
1
vote
1answer
71 views
Is storing values of a unique field shared between many web forms bad practice?
I am curious if it is considered a bad practice to use a unique table to store values asigned to a unique field that is shared between several webforms.
The site with webforms will carry thousands or ...
