|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#31
January 26th, 2006, 05:19 AM
|
||||
|
||||
|
Quote:
 JMH - now that you also gave your SQL, you can add yourself to the list!! 
|
|
#32
January 26th, 2006, 07:11 PM
|
|||
|
|||
|
Quote:
lol, but Shadow...that wasn't anything to show off about!
__________________
jmurrayhead Did I help you out? Make me popular by clicking the  icon!New Members:Proper way to post a question Powered by ASP.Net
|
|
#33
January 27th, 2006, 05:06 AM
|
||||
|
||||
|
that was valid SQL statement - less than 0.01% of the world population can do that...
|
|
#34
January 27th, 2006, 12:05 PM
|
|||
|
|||
|
Quote:
lol I suppose you are right then 
|
|
#35
January 28th, 2006, 12:55 PM
|
||||
|
||||
|
am i the only one who feels some of those queries are a little overdone ? would it not be simpler to run multiple shorter queries and check the data sets returned along the way ? thats what i would do with PHP and mysql anyways... but i dont know about efficiency of querying and the like.. i usually work and on low traffic intranet applications. I usually like to take some of the load of the db and split it on to the webserver.. thats usually coz the db machines I've some across are usually not as high performing as the ones where the webserevrs are running...
but this is out of my league SQL stuff... way out...we got SQL guys (working with oracle) who do the data mining and massive data storage apps...
__________________
The member formerly known as David Beckham  Manchester United Forever  Never argue with fools. They will bring you down to their level and beat you with experience.  
|
|
#36
January 28th, 2006, 01:07 PM
|
||||
|
||||
|
I agree with you oneMSBI, if it was an ASP app that I was working with, I would go with the several smaller queries ... but this is basically a datascrub that I need to send to a company for marketing purposes ...
__________________
Come JOIN the party!!! Quote of the Month: Retirement: Because you've given so much of yourself to the company that you don't have anything left we can use. Questions to Ponder: What do you do when you see an endangered animal eating an endangered plant? iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm") copyright© 2008 sbenj69
|
|
#37
January 28th, 2006, 03:01 PM
|
||||
|
||||
|
Nope. Stored procedures are much faster than queries in
code. Can't comment for php mysql though
__________________
And he picked it all up... in his pick-up.  Friends of Shemzilla
|
|
#38
January 29th, 2006, 05:21 AM
|
||||
|
||||
|
what I've posted is trigger - it's chunk of code automatically executed when something
happens, e.g. record is inserted or updated in specific table. it's cool feature of SQL Server, can't do this in ASP...
|
|
#40
January 30th, 2006, 08:24 AM
|
||||
|
||||
|
Quote:
|
|
| Viewing: ASP Free Forums > Other > ASP Free Lounge > To JMH |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
