Hi, I am using my sql CAPI.I am able to access the database well but there is one performance issue that came into my mind. Is it better to have a single query on multiple tables using joins? (OR) Multiple queries without joins on each table,in a sequential order . If I use joins also,there won't be more than 3 tables. I got the issue especially keeping in view of the factor that I am using C API and I can achieve the effect of having joins through C/C++ language. Regards, Ravi ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php