 | [Solved] SQL Question |  |
 Posted: 08/31/2007 6:52 AM |
 |
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
 |
|
|
|
Joined: Jan 06, 2006
Local time: 9:56 PM
|
|
|
|
|
 |
Just reading the instructions above again...if I have SQL queries all doing different things to different tables can I run them all together at the same time?
I've been doing them all individually, and opening up each table if necessary  I'm still a bit weary of anything involving databases  |
|
Last edited by Karen on 09/01/2007 10:52 AM; edited 1 time in total |
|
|
|
| Back to Top |
|
|
| Re: SQL Question | |
| Posted: 08/31/2007 3:59 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
 |
|
|
|
Joined: Sep 25, 2004
Local time: 5:56 PM
Location: St Pete, FL
|
|
|
|
|
|
SQL is single threaded, meaning that it has to complete on query before it can move on to the next. So you can run them all at once, but in reality, they are running one at a time. It won't hurt to run 1000 queries at the same time. The server will handle them in the order that they arrive...
 |
|
|
|
|
| Back to Top |
|
|
| Re: SQL Question | |
| Posted: 08/31/2007 4:11 PM |
|
|
|
|
|
| Citation |
| Posts |
1253 |
| Word Cnt. |
68,166 |
| BDay |
Nov 9 |
| Sign |
Scorpio |
| Sex |
|
|
|
|
Joined: Jan 06, 2006
Local time: 9:56 PM
|
|
|
|
|
|
Great thanks!
That will save some time then  |
|
|
|
|
| Back to Top |
|
|
| Re: SQL Question | |
| Posted: 08/31/2007 5:40 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 5:56 PM
Location: St Pete, FL
|
|
|
|
|
|
Yes, it should save you time if you were running them one at a time. That could get old real fast...
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
