Results 1 to 3 of 3

Thread: Speed of a Query

  1. May 20th, 2003, 03:49 PM #1
    TheGoldenShogun
    TheGoldenShogun is offline

    Thread Starter
    Addicted Member TheGoldenShogun's Avatar
    Join Date
    Mar 2001
    Location
    VA/MD... anywhere around the beltway
    Posts
    236

    Cool Speed of a Query

    What is better to use? A series of small SQL statements or trying to amass one big one, complete with joins and calls to all the tables you need? By better I mean which one is faster and more effectient. I would imagine that the big one would be best but I gotta believe calling all those tables at once is slower than quick little calls with short SQL statements.
    Reply With Quote Reply With Quote
  2. May 22nd, 2003, 11:25 AM #2
    phpman
    phpman is offline
    Frenzied Member
    Join Date
    Nov 1999
    Posts
    1,337
    I would also think a mass query with joins is faster. less code too. but never really paid attention to that.
    Reply With Quote Reply With Quote
  3. May 26th, 2003, 02:46 AM #3
    CornedBee
    CornedBee is offline
    Kitten CornedBee's Avatar
    Join Date
    Aug 2001
    Location
    In a microchip!
    Posts
    11,594
    Large, I'm quite sure.

    Unless it forces you to use a function that is slow on your particular DB, e.g. MySQL has some weaknesses in performance somewhere.
    All the buzzt
    CornedBee

    "Writing specifications is like writing a novel. Writing code is like writing poetry."
    - Anonymous, published by Raymond Chen

    Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width