setBackend,Spectra,MsBackend uses by default some chunk-wise processing, which is not supported by backendInitialize of the SQL backends due to creation of the database and database tables, setting the spectra IDs (primary keys) and finally also the indices for the database.
Disabling chunk-wise (and parallel) processing using f = factor() would still work, but then the full data will be loaded into memory at once. As alternative, a setBackend,Spectra,MsBackendSql could be implemented that addresses these specific needs from above and supports chunk-wise loading and inserting the data to the database.
jorainer
commented
9 months ago
setBackend,Spectra,MsBackenduses by default some chunk-wise processing, which is not supported bybackendInitializeof the SQL backends due to creation of the database and database tables, setting the spectra IDs (primary keys) and finally also the indices for the database.Disabling chunk-wise (and parallel) processing using
f = factor()would still work, but then the full data will be loaded into memory at once. As alternative, asetBackend,Spectra,MsBackendSqlcould be implemented that addresses these specific needs from above and supports chunk-wise loading and inserting the data to the database.