Re: [sqlite] beginner question: help required to retrieve "filename" from an open "sqlite3*" handle

On 4 February 2011 07:38, Andreas Otto wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi, > > with "sqlite2_open" the parameter "filename" is used to specify the > database location. > > Q: how I can retrieve this parameter from an open handle?

[sqlite] beginner question: help required to retrieve "filename" from an open "sqlite3*" handle

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, with "sqlite2_open" the parameter "filename" is used to specify the database location. Q: how I can retrieve this parameter from an open handle? sqlite-version: latest mfg, Andreas Otto -BEGIN PGP SIGNATURE- Version: GnuPG v2.0.15

Re: [sqlite] beginner question

--- Dennis Cote <[EMAIL PROTECTED]> wrote: > Qiang wrote: > > hello, > > > > two questions.. > > > > 1. comparing select one or two columns from one > row > > from a bigger table ( 20,000 - 30,000 rows, 20 > columns > > ). > >with > >select the same column from one row from a > smaller

Re: [sqlite] beginner question

Qiang wrote: hello, two questions.. 1. comparing select one or two columns from one row from a bigger table ( 20,000 - 30,000 rows, 20 columns ). with select the same column from one row from a smaller table (20,000 - 30,000 rows, 2 columns). does it make much different on

[sqlite] beginner question

hello, two questions.. 1. comparing select one or two columns from one row from a bigger table ( 20,000 - 30,000 rows, 20 columns ). with select the same column from one row from a smaller table (20,000 - 30,000 rows, 2 columns). does it make much different on performance? if yes, what