Click here to Skip to main content
15,501,036 members
Home / Discussions / Database
   

Database

 
GeneralRe: Max. number of concurrent user in PostGre database Pin
jschell18-Aug-11 14:02
Memberjschell18-Aug-11 14:02 
GeneralRe: Max. number of concurrent user in PostGre database Pin
Navin Pandit18-Aug-11 19:33
MemberNavin Pandit18-Aug-11 19:33 
GeneralRe: Max. number of concurrent user in PostGre database Pin
jschell19-Aug-11 8:34
Memberjschell19-Aug-11 8:34 
QuestionSearching with optional parameters [modified] Pin
Pascal Ganaye16-Aug-11 2:36
MemberPascal Ganaye16-Aug-11 2:36 
AnswerRe: Searching with optional parameters Pin
PIEBALDconsult16-Aug-11 4:23
professionalPIEBALDconsult16-Aug-11 4:23 
GeneralRe: Searching with optional parameters Pin
Pascal Ganaye16-Aug-11 5:16
MemberPascal Ganaye16-Aug-11 5:16 
AnswerRe: Searching with optional parameters Pin
Pascal Ganaye16-Aug-11 5:21
MemberPascal Ganaye16-Aug-11 5:21 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult16-Aug-11 18:56
professionalPIEBALDconsult16-Aug-11 18:56 
Pascal Ganaye wrote:
we can assume it will be optimized and cached


As I understand it, in SQL Server every statement is cached, and may get pushed out of the cache. I assume that this way will also cause the dynamic SQL to be cached separately from the main SQL. So I don't think there's any appreciable savings over the non-stored-procedure way.
GeneralRe: Searching with optional parameters Pin
Mycroft Holmes16-Aug-11 19:06
professionalMycroft Holmes16-Aug-11 19:06 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult17-Aug-11 3:48
professionalPIEBALDconsult17-Aug-11 3:48 
GeneralRe: Searching with optional parameters Pin
Mycroft Holmes17-Aug-11 6:40
professionalMycroft Holmes17-Aug-11 6:40 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult17-Aug-11 15:11
professionalPIEBALDconsult17-Aug-11 15:11 
GeneralRe: Searching with optional parameters Pin
S Douglas20-Aug-11 8:53
professionalS Douglas20-Aug-11 8:53 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult20-Aug-11 14:01
professionalPIEBALDconsult20-Aug-11 14:01 
QuestionRe: Searching with optional parameters Pin
Shameel16-Aug-11 5:52
professionalShameel16-Aug-11 5:52 
AnswerRe: Searching with optional parameters Pin
Pascal Ganaye16-Aug-11 7:02
MemberPascal Ganaye16-Aug-11 7:02 
GeneralRe: Searching with optional parameters Pin
PIEBALDconsult16-Aug-11 19:04
professionalPIEBALDconsult16-Aug-11 19:04 
QuestionSQL bit to bool conversion [moved] Pin
5fingers16-Aug-11 1:37
Member5fingers16-Aug-11 1:37 
GeneralRe: SQL bit to bool conversion Pin
Nagy Vilmos16-Aug-11 1:39
professionalNagy Vilmos16-Aug-11 1:39 
GeneralRe: SQL bit to bool conversion Pin
Shameel16-Aug-11 5:53
professionalShameel16-Aug-11 5:53 
GeneralRe: SQL bit to bool conversion Pin
5fingers17-Aug-11 1:59
Member5fingers17-Aug-11 1:59 
GeneralRe: SQL bit to bool conversion Pin
Dalek Dave16-Aug-11 1:39
professionalDalek Dave16-Aug-11 1:39 
GeneralRe: SQL bit to bool conversion Pin
5fingers17-Aug-11 1:57
Member5fingers17-Aug-11 1:57 
GeneralRe: SQL bit to bool conversion Pin
chriselst16-Aug-11 1:40
Memberchriselst16-Aug-11 1:40 
GeneralRe: SQL bit to bool conversion Pin
CPallini16-Aug-11 1:45
mveCPallini16-Aug-11 1:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.