I mean only compare the two ways of get the database handl. 1.sqlite3_open 2.ATTACH DATABASE Do not consider the next operation, such as select,update and so on.
At 2015-12-16 10:51:31, "Richard Hipp" <drh at sqlite.org> wrote: >On 12/15/15, ??? <2004wqg2008 at 163.com> wrote: >> hi,all >> There are two ways to open a database. >> 1.sqlite3_open >> 2.ATTACH DATABASE >> >> Because there are so many data base. So we used attach database to open >> them. >> But the efficiency of the programming is not ideal. >> >> which one is faster? >> Is the efficiency between the two methods great? >> > >I think both methods are about the same speed. Have you measured a >difference between them? They both do about the same amount of work, >I think. > >-- >D. Richard Hipp >drh at sqlite.org >_______________________________________________ >sqlite-users mailing list >sqlite-users at mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users