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 Link to comment https://forums.phpfreaks.com/topic/48526-real-dumb-question/ 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. Link to comment https://forums.phpfreaks.com/topic/48526-real-dumb-question/#findComment-237416 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.