Sorry I writed it in Spanish and see it now. Translation:
The problem is that the server receives all the data in a transmission buffer, piece by piece without knowing the structured object. So I'm storing it in a file because the server doesn't need to open it (it only needs to read small data). If I want to put all the attributes in the SQL tables, I will have to take all the fragments and build the structured object in memory, and this, as I understand it, is a problem. I don't know if my ideas are correct or am I missing something. El miércoles, 2 de noviembre de 2022 a las 18:22:04 UTC+1, Jose mi escribió: > El problema es que el servidor recibe todos los datos en un búfer de > transmisión, pieza por pieza sin conocer el objeto estructurado. Así que lo > estoy almacenando en un archivo porque el servidor no necesita abrirlo > (solo necesita leer datos pequeños). Si quiero poner todos los atributos en > las tablas SQL, tendré que tomar todos los fragmentos y construir el objeto > estructurado en la memoria, y esto, según tengo entendido, es un problema. > No sé si mis ideas son correctas o me estoy perdiendo algo. > > -- Josemi. > > El martes, 1 de noviembre de 2022 a las 3:45:12 UTC+1, [email protected] > escribió: > >> >> > On Oct 31, 2022, at 12:21 PM, Josemi <[email protected]> wrote: >> > >> > Hello. >> > >> > I need to work with a structured data that have atributes with >> undefined lenght, some of them could have GB. >> >> Most structured storage is optimized for smaller data. And huge values >> in-line push all the records far apart, which is bad for cache performance. >> >> SQLite supports arbitrary size blobs up to 2^64 bytes. (Even with that >> it’s best to put the blobs in a separate table and join your records to >> it.) >> >> —Jens >> > -- You received this message because you are subscribed to the Google Groups "Cap'n Proto" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/capnproto/103e3505-2ced-4a70-8801-6caccddfd825n%40googlegroups.com.
