Hello
I have these database
countries
->country_id
->country_name
->language
counties
->county_id
->county_name
->language
towns
->town_id
->town_name
->language
locations
->location_id
->location_name
->language
streets
->street_id
->street_name
->language
and i have users that select country,county,town,location and optional street at a selected language and i want to show the show the informations of address quicker than joining all these tables how i can do this? Using index that has all the informations?
Thank you very much
xxmp
0
Light Poster
Recommended Answers
Jump to Postand i have users that select country,county,town,location and optional street at a selected language and i want to show the show the informations of address quicker than joining all these tables how i can do this?
Maybe I misunderstood your question. You want to fetch the data quicker …
Jump to Postbut i do not have any indexes for now. Will be better to change the shema of databases or use indexes?
I would index it. You have to understand the query doesn't really affect how fast you fetch the data.
All 7 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.