Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Versions des environnements
SQL Server:
SQL Server 2005
>>>Ducking issues again? Seriously, how can you justify 100's of round trips to the data base to "keep it clean and simple" vs 1 single call to get all data?
>>
>>Seriously, I do not call a round trip to the server a big hit. That's just the way it's done. My point was based on software maintenance, which is way more expensive than server hits.
>
>Round trip to the server is a hit. If you can do one SP that works with the list in one call (in SQL 2008 and up you better pass this table as TVP) then go for it and not for 100 individual calls. The performance is important.
Naomi, I know performance is important. I didn't just fall off the turnip truck. It's just that the thought of a call with quote, hundreds or thousands, unquote of parameters makes me nervous.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement