jaymc Posted April 24, 2007 Share Posted April 24, 2007 Ive been doing MYSQL for a while but Ive just been reading a topic on here and realised you can select data from numerous tables in one query by adding the tablename.field Just wondering, is this quicker than having 2 seperate queries and if so is it dramatically quicker in the sense of 50%? Even if it is in mili seconds Feedback please Quote Link to comment Share on other sites More sharing options...
chombone Posted April 24, 2007 Share Posted April 24, 2007 I work mainly with Oracle SQL but the principle is the same. It depends. A well written query can return data from multiple tables very, very quickly. A badly written one can freeze the entire database! There are many techniques for performance-tuning queries but they are way too numerous to list here. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.