As any random subset of the rows in any of the CACHED tables can be held in the cache, the amount of memory needed by cached rows can reach the sum of the rows containing the largest field data. In all running modes server or in-process multiple connections to the database engine are supported.

This would result in unnecessary memory and speed overheads. The second general reason to chunk SQL commands is if your database requires you to send multiple commands in one transmission.

In the above examples the first one refers to a set of mydb. If you want a new file, then use a new file name or remove the pre-existing target file ahead of time. The file path specifies the database file.