Click here to Skip to main content
16,016,801 members
Home / Discussions / C#
   

C#

 
AnswerRe: c# Pin
Richard MacCutchan24-Jul-23 0:03
mveRichard MacCutchan24-Jul-23 0:03 
QuestionWhat should be the principles of multilayer software design? Pin
farshad valizade 202323-Jul-23 22:00
farshad valizade 202323-Jul-23 22:00 
AnswerRe: What should be the principles of multilayer software design? Pin
Richard Deeming23-Jul-23 23:11
mveRichard Deeming23-Jul-23 23:11 
QuestionMulti-threading Pin
MAW3017-Jul-23 9:52
MAW3017-Jul-23 9:52 
AnswerRe: Multi-threading Pin
Gerry Schmitz17-Jul-23 15:32
mveGerry Schmitz17-Jul-23 15:32 
AnswerRe: Multi-threading Pin
Dave Kreskowiak17-Jul-23 15:53
mveDave Kreskowiak17-Jul-23 15:53 
QuestionParameterized Query Pin
Richard Andrew x6416-Jul-23 8:47
professionalRichard Andrew x6416-Jul-23 8:47 
AnswerRe: Parameterized Query Pin
Dave Kreskowiak16-Jul-23 10:44
mveDave Kreskowiak16-Jul-23 10:44 
I don't think you have much of a choice. Sqlite doesn't support any bulk insert so you're either going to reuse the same command over and over again or build a block of inserts.

You also have a command length limit of 1GB but, unless you go nuts building a huge block of insert statements, you'll not likely hit that.

The other problem is a limit on the number of parameters you can have. The default using numbered named parameters is 32766 for recent versions of Sqlite.

Quote:
Maximum Number Of Host Parameters In A Single SQL Statement

A host parameter is a place-holder in an SQL statement that is filled in using one of the sqlite3_bind_XXXX() interfaces. Many SQL programmers are familiar with using a question mark ("?") as a host parameter. SQLite also supports named host parameters prefaced by ":", "$", or "@" and numbered host parameters of the form "?123".

Each host parameter in an SQLite statement is assigned a number. The numbers normally begin with 1 and increase by one with each new parameter. However, when the "?123" form is used, the host parameter number is the number that follows the question mark.

SQLite allocates space to hold all host parameters between 1 and the largest host parameter number used. Hence, an SQL statement that contains a host parameter like ?1000000000 would require gigabytes of storage. This could easily overwhelm the resources of the host machine. To prevent excessive memory allocations, the maximum value of a host parameter number is SQLITE_MAX_VARIABLE_NUMBER, which defaults to 999 for SQLite versions prior to 3.32.0 (2020-05-22) or 32766 for SQLite versions after 3.32.0.

The maximum host parameter number can be lowered at run-time using the sqlite3_limit(db,SQLITE_LIMIT_VARIABLE_NUMBER,size) interface.


GeneralRe: Parameterized Query Pin
Richard Andrew x6416-Jul-23 11:39
professionalRichard Andrew x6416-Jul-23 11:39 
AnswerRe: Parameterized Query Pin
OriginalGriff16-Jul-23 11:24
mveOriginalGriff16-Jul-23 11:24 
GeneralRe: Parameterized Query Pin
Richard Andrew x6416-Jul-23 11:42
professionalRichard Andrew x6416-Jul-23 11:42 
GeneralRe: Parameterized Query Pin
OriginalGriff16-Jul-23 18:34
mveOriginalGriff16-Jul-23 18:34 
GeneralRe: Parameterized Query Pin
Richard Andrew x6417-Jul-23 5:35
professionalRichard Andrew x6417-Jul-23 5:35 
AnswerRe: Parameterized Query Pin
Gerry Schmitz16-Jul-23 19:32
mveGerry Schmitz16-Jul-23 19:32 
GeneralRe: Parameterized Query Pin
Richard Andrew x6417-Jul-23 5:33
professionalRichard Andrew x6417-Jul-23 5:33 
QuestionGetting a VST3 effect name and vendor Pin
spice3d8-Jul-23 9:19
spice3d8-Jul-23 9:19 
AnswerRe: Getting a VST3 effect name and vendor Pin
Pete O'Hanlon8-Jul-23 10:09
mvePete O'Hanlon8-Jul-23 10:09 
GeneralRe: Getting a VST3 effect name and vendor Pin
spice3d8-Jul-23 11:18
spice3d8-Jul-23 11:18 
QuestionAdvices for my learning path Pin
coco2437-Jul-23 21:10
coco2437-Jul-23 21:10 
AnswerRe: Advices for my learning path Pin
OriginalGriff7-Jul-23 21:19
mveOriginalGriff7-Jul-23 21:19 
AnswerRe: Advices for my learning path Pin
Richard Andrew x648-Jul-23 3:26
professionalRichard Andrew x648-Jul-23 3:26 
GeneralRe: Advices for my learning path Pin
coco2439-Jul-23 9:07
coco2439-Jul-23 9:07 
GeneralRe: Advices for my learning path Pin
jschell10-Jul-23 3:50
jschell10-Jul-23 3:50 
AnswerRe: Advices for my learning path Pin
BillWoodruff9-Jul-23 15:06
professionalBillWoodruff9-Jul-23 15:06 
GeneralRe: Advices for my learning path Pin
coco24310-Jul-23 18:34
coco24310-Jul-23 18:34 

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.