>It also opens and closes the database file for each query which can be >expensive.
Want to know how expensive is opening and closing a connection is? Does sqlite3_open16 have to do any validations or so. (Of course it would have to) but wanted to know how costly they are. ... Chetana. ----- Original Message ---- From: Dennis Cote <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Tuesday, October 24, 2006 9:02:12 PM Subject: Re: [sqlite] Sqlite & Matlab [EMAIL PROTECTED] wrote: > There seems to be a possible connection between Sqlite and Matlab available at > http://sourceforge.net/project/showfiles.php?group_id=139986 > > However it is not refered to on the sqlite website. Does that mean it does not > really work? > > > Victor, I took a quick look at the code there. It hasn't been updated for a year or so, but it seems like it should be functional as is. It should work OK for small result sets, since it loads the entire result set into memory. Actually it ends up with two copies in memory while it is converting the data from sqlite to matlab formats. It also opens and closes the database file for each query which can be expensive. HTH Dennis Cote ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
