Menu

#1 Increase maximum attached database

1.0
closed
None
2016-08-14
2016-06-03
agentofc
No

Hi, thanks for your works.
Can you increase the maximum attached database to the maximum hard limit for later version.
In https://www.sqlite.org/limits.html the maximum attached database is 10 by default. But can be increased up to 125.

Thanks.

Discussion

  • Jan Nijtmans

    Jan Nijtmans - 2016-06-03

    Thanks for the suggestion. Would a value of 62 suffice for you? With that value, a 64-bit integer value can be used for storing a bit mask related the attached database, so this can be done without losing efficienty. A higher value than that seems not useful to me, it would be less efficient whily hardly anyone would use that

     
  • agentofc

    agentofc - 2016-06-04

    Refer to the discussion in the mailing list. The author of sqlite himself said it was 125.
    http://sqlite.1065341.n5.nabble.com/attach-db-limit-td87885.html

    But I can do with 62. For now.

    Thanks.

     
  • agentofc

    agentofc - 2016-08-13

    Thanks for 3.14 update. I just tested, attach database working fine with more than 10.
    I notice at the same day you release 3.14, official SQLite team release 3.14.1. Maybe you will kind enough to release the latest version too.

    Thanks.

     
  • Jan Nijtmans

    Jan Nijtmans - 2016-08-14
    • status: open --> closed
    • assigned_to: Jan Nijtmans
     
  • Jan Nijtmans

    Jan Nijtmans - 2016-08-14

    Fixed now, default value increased to 62.

     

Log in to post a comment.