Thanks Robert... very informative.
----- Original Message ----- From: "Robert Simpson" <[EMAIL PROTECTED]> To: "'General Discussion of SQLite Database'" <sqlite-users@sqlite.org> Sent: Tuesday, July 15, 2008 9:58 PM Subject: Re: [sqlite] General help, a bit OT > Without causing a rehash of that long-debated topic, I'll say this: As it > relates to SQLite, generally you will get better performance out of an > optimized C application talking to SQLite than you will out of .NET > talking > to SQLite. > > The difference can be insignificant to a user application however -- as > someone is probably not going to notice the difference between your C app > inserting 100,000 rows a second vs. .NET's 90,000 rows a second. > > I did a simple insert/read/update test comparing the ADO.NET provider to > raw > C++, results here: > > http://sqlite.phxsoftware.com/forums/t/19.aspx > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of cstrader > Sent: Tuesday, July 15, 2008 5:36 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] General help, a bit OT > > is it true that C is always (or even generally) faster than .net? > > > ----- Original Message ----- > From: "Szomraky, Stefan" <[EMAIL PROTECTED]> > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Sent: Tuesday, July 15, 2008 8:40 AM > Subject: Re: [sqlite] General help, a bit OT > > >>> -----Original Message----- >>> From: [EMAIL PROTECTED] >>> [mailto:[EMAIL PROTECTED] On Behalf Of cstrader >>> Sent: Tuesday, July 15, 2008 2:28 PM >>> To: General Discussion of SQLite Database >>> Subject: Re: [sqlite] General help, a bit OT >>> >>> Oh, sorry, the example was just an example. The calculations >>> I need to make on on ColC cannot be done within SQLite. >>> >>> > Why does SELECT ColA, ColB, ColA+ColB AS ColC FROM tab1; not work? >>> > >> >> AFAIK, the current .NET provider for SQLITE supports custom functions >> implemented in .NET. >> Maybe this will work? >> >> SELECT ColA, ColB, custCLRfct(ColA, ColB) AS ColC FROM tab1; >> >> You might also want to implement the function in C for speed >> improvements. >> >> Greetings, >> Stefan. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
