/    Sign up×
Community /Pin to ProfileBookmark

2 tables or one big in mysql ?

Copy linkTweet thisAlerts:
Sep 12.2007

Hi,

I have 2 big tables (400.000 entries) and I wondered what would the fastest option: to give an easy exemple, imagine 2 tables where each row is a car model and each column some stuff about the cars (10 columns of details). Is it faster to search a car in both table and retrieve the results or to make a mega table with 20 columns?
thanks for your suggestions !

to post a comment
PHP

1 Comments(s) ↴

Copy linkTweet thisAlerts:
@michael879Sep 12.2007 — Speed-wise its exactly the same (it may be slightly slower to do 2 tables). Logically tho, it would make a lot more sense to have 1 table, and add a type field to it (i.e. 1 giant database with 21 columns).
×

Success!

Help @patimages spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 5.20,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...