Re: [h2] database benchmark performace mysql vs cache vs system vs directory file

I'm sorry to say, but you need to do more reading on how caches work, that is not at all how it functions. A brief overview of our architecture is here: http://h2database.com/html/architecture.html When people say that SQLite is faster than the filesystem, they mean it is faster for the specific

Re: [h2] database benchmark performace mysql vs cache vs system vs directory file

as I understand it, this is copying and pasting a frequent part of the storage file into another smaller storage file. but I was wondering if it would be faster to insert data directly into the directory system instead of storage files. on the internet there are several theories, but none shows

Re: [h2] database benchmark performace mysql vs cache vs system vs directory file

Not really, look up how an LRU cache works e.g. https://en.wikipedia.org/wiki/Cache_replacement_policies -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-datab

Re: [h2] database benchmark performace mysql vs cache vs system vs directory file

has cache to analyze the frequency of the line and position it for a faster query in the future based on the probability that the lines appear? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving ema

Re: [h2] database benchmark performace mysql vs cache vs system vs directory file

On Sat, 11 Apr 2020 at 21:04, Danilo Santos wrote: > exists one https://database.serverbenchmark.com/ like > https://gpu.userbenchmark.com/ or https://cpu.userbenchmark.com/ > > > Not that I am aware of. Lots of databases prohibit the publication of unauthorised b

[h2] database benchmark performace mysql vs cache vs system vs directory file

exists one https://database.serverbenchmark.com/ like https://gpu.userbenchmark.com/ or https://cpu.userbenchmark.com/ why are there still people using mysql instead of 1 portable database like h2database? how does the database cache system work? is it faster t