BluePin Comments - Answer Overflow

I just used introspect to pull up a bench. The partitions came as separate tables... this is really bad. tb_example_1 tb_example_2 tb_example_3 tb_example_4

2 replies

DTDrizzle Team

•Created by textYash on 3/21/2024 in #help

How to write a good username schema?

{
  id: bigserial("id", { mode: "bigint" }).notNull().primaryKey()
}

{
  id: bigserial("id", { mode: "bigint" }).notNull().primaryKey()
}

6 replies

DTDrizzle Team

•Created by textYash on 3/21/2024 in #help

How to write a good username schema?

There is a difference in the ability of banks to share information. When you use integer the identification process is 123 to 123. Easy. But for String it is textYash t 2000 results te 1500 tex 100 text 2 results textY 1 result textYash result confirmed. That's not exactly how it does it... But it's an optimized Char dataTypes search algorithm. That's why a string is an "Array[]" of char. So you have to parce each character. an integer is stored in just one memory address. So it is faster to compare. And if you use bigint serial for id and use it with index activated, it will be super quick to find this user. If you have table partitioning logic you can still create user partitions. All this applied will make a super fast search. Furthermore, using unic in primarykey is not necessary. Because no primary key can be repeated, that is, it is already unique and null cannot be inserted in the primary key, so it is necessary to use .notNull. That said, good luck.

6 replies

Gaming

Programming