[h2] possible to add these functions?

Hi All possible to add these functions? select hex(column) <-- display hex select hex(column) & 0xff <-- get the last byte thanks Peter -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving

Re: [h2] hex

no, i have a column which is integer, I want to display it as hex. thanks On Tuesday 16 January 2024 at 21:38:20 UTC+8 Andreas Reichel wrote: > On Tue, 2024-01-16 at 05:24 -0800, mche...@gmail.com wrote: > > Hi >possible to add a function to convert dec to hex for display? > &

[h2] hex

Hi possible to add a function to convert dec to hex for display? select hex(col) from table thanks Peter -- 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

Re: [h2] push the insert speed to max

10k. thanks Andreas On Sunday 14 January 2024 at 01:21:36 UTC+8 mche...@gmail.com wrote: > 1xk mean i can insert 10-15 thousand records to h2 per second, thanks > > On Friday 12 January 2024 at 16:41:03 UTC+8 Andreas Reichel wrote: > >> Forgot one: >> >> try multi t

Re: [h2] push the insert speed to max

if this really will be faster though. > > On Fri, 2024-01-12 at 15:38 +0700, Andreas Reichel wrote: > > Greetings. > > On Fri, 2024-01-12 at 00:17 -0800, mche...@gmail.com wrote: > > hi. I am running AMD 3900x with 128GB ram and a nvme ssd. Now i can insert > 1xk record per secon

[h2] push the insert speed to max

hi. I am running AMD 3900x with 128GB ram and a nvme ssd. Now i can insert 1xk record per seconds, which is very fast. But how can I make is 10 times more? what hardware can do that? thanks Peter -- You received this message because you are subscribed to the Google Groups "H2 Database" group.

Re: [h2] why insert many record to in-memory database is same speed as embedded-mode

ase). > Some significant short-cuts can be taken under assumption of a > single-client use (non-transactional, non-concurrent), but that is the > topic for a wish list. > > On Tuesday, January 9, 2024 at 8:26:58 AM UTC-5 mche...@gmail.com wrote: > >> no, my program use

Re: [h2] why insert many record to in-memory database is same speed as embedded-mode

Mon, 2024-01-08 at 09:20 -0800, mche...@gmail.com wrote: > > hi. >why insert many record to in-memory database is same speed as > embedded-mode. In-mem should be much faster, right? > > > import java.io.FileNotFoundException; > import java.io.IOException; &g

[h2] why insert many record to in-memory database is same speed as embedded-mode

hi. why insert many record to in-memory database is same speed as embedded-mode. In-mem should be much faster, right? import java.io.FileNotFoundException; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import

[h2] Re: is there any command line interface can interact with h2 in shell

thanks On Sunday 31 December 2023 at 14:26:03 UTC+8 Evgenij Ryazanov wrote: > Hi! > > You can use the shell tool: > https://h2database.com/html/tutorial.html#shell_tool -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this

[h2] is there any command line interface can interact with h2 in shell

hi is there any command line interface can interact with h2 in shell? Thanks -- 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] Re: out of memory after executeBatch

data.size() % 10 == 0 > || data.size() < 10) looks suspicious. Let's assume prepopulated data > of size > 10 * 12345 +1 > You may end up committing batch of size 1.2 billion+, wchich would totally > explain OOM.. > > On Tuesday, November 21, 2023 at 5:41:30 AM UT

[h2] out of memory after executeBatch

Dear All I keep clicking the data to h2 by stmt.addBatch(), after i called executeBatch, memory is not free, so finally out of memory, may i know why please? @Override public void run() { while (!stopped) { synchronized (sharedLock) { try { // System.out.println("data.size() =" +

Re: [h2] Re: show hex value

thank you sir On Sunday, 22 January 2023 at 10:01:17 UTC+8 Evgenij Ryazanov wrote: > Hello! > > There is a RAWTOHEX > function, you can convert this integer number to a BINARY(4) data type > and pass the result to this function: > SELECT

[h2] Re: show hex value

hi , possible to show an integer in hex format? On Wednesday, 4 January 2023 at 16:55:47 UTC+8 Evgenij Ryazanov wrote: > Hi! > > H2 Console already displays values of binary strings in hexadecimal > format, if you need a similar feature in other tool you should ask its > developers instead. >

[h2] index doesn't help

Hi all This query select sequence,mem,memaddr,memvalue, memRead from data where mem or irqRequest order by sequence where mem <-- fast where irqRequest <-- fast where mem or irqRequest <-- very slow create index mem on data(mem); create index irqRequest on data(irqRequest); create index

[h2] show hex value

hi possible to show show hex value from select? thanks Peter -- 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-database+unsubscr...@googlegroups.com. To view

[h2] index problem

hi, i got 18 millions role, i select and order with a column with index, very fast. Then i manually changed nearly all the values of that column, select become very slow, seems the index won't rebuild after i changed the column values, how to prevent it? thanks -- You received this message

[h2] Re: int not 100% continuous

thank you very much :-) On Sunday, 18 December 2022 at 19:47:59 UTC+8 Evgenij Ryazanov wrote: > Hi! > > If you don't care about exact ordering, the fastest way is > UPDATE tableName SET columnName = ROWNUM(); > > If you want to preserve it, a slower command is needed: > MERGE INTO tableName

[h2] index doesn't speed up

hi i have 20 millions rows , and this index doesn't speed up the query, please help: create index mem on data(mem, sequence); select * from data where mem is not null order by sequence mem is varchar(200); and sequence is bigint thanks -- You received this message because you are

[h2] int not 100% continuous

hi i have column which is bigint and not int not 100% continuous , so the data is [1,2,36,10,11] , now i want to reinput the data ane make it continuouse, such as [1,2,3,4,5,6]. I got 20 millions rows, what is the fastest way to do this? thanks Peter -- You received this message because

[h2] When we have driver to connect H2 from php

hi all, When we have driver to connect H2 from php? thanks Peter -- 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-database+unsubscr...@googlegroups.com. To

[h2] how to connect h2 using php

hi, how to connect h2 using php? thx -- 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-database+unsubscr...@googlegroups.com. To view this discussion on the web