#2 Re: mORMot 1 » can mormot1 run in Docker? » 2024-03-15 09:09:24

thank you very much for your answer,   mormot has been applied to my production environment(currently very small),it's fantastic

#6 Re: mORMot 2 » Ask a query question » 2023-08-06 05:36:57

Just because I need to synchronize some data to MSSQL, but there are some deletion operations , which results in unequal IDs on both sides. Therefore, I need count (*) to determine where to continue synchronizing.(Mainly because I didn't consider the issue of deletion at the beginning) 。
I have been using Mormot, which is a great framework。
Thank you very much for your answer。

#7 Re: mORMot 2 » Ask a query question » 2023-08-05 05:08:13

I did not use the 'where' condition, just simply obtained the total number of tables. I will try again:)

#8 mORMot 2 » Ask a query question » 2023-08-04 05:46:10

zhangguichao
Replies: 4

If an index other than the ID field is created, the count (*) speed of sqlite will increase significantly, resulting in a data overhaul of 10000000 entries. Who knows why?
Only ID index   4s
Add another index  1.3s

#10 Re: mORMot 1 » About Big Data Support » 2023-07-28 04:36:47

If you don't use MongoDB cluster and only rely on sqlite, is there a feasible method for statistical analysis of Big data?:)

#11 Re: mORMot 2 » High-Performance Frameworks » 2023-07-28 00:35:25

I understand, thank you. I still prefer sqlite for updates. It is very convenient and meets most needs, right?  smile

#12 Re: mORMot 2 » High-Performance Frameworks » 2023-07-27 05:36:54

Just to ask, why doesn't sqlite be used for this test? smile

#14 mORMot 2 » Can someone help me ? » 2023-07-09 15:37:14

zhangguichao
Replies: 2

I want to use Mormot to create a PDF file that supports Chinese fonts, such as' 宋体 ',Can someone give me a simple demo? Thank you very much。
(i use lazarus with fpc3.2.2)

#15 Re: mORMot 1 » ICU extension for SQLite » 2023-07-05 08:07:27

@Aknehsas  您好,我也遇到了同样的问题,能提供一个例子吗?包含dll(如果需要的话),十分感谢。

#16 Re: mORMot 1 » ISQLDBRows always causes memory leaks in lazarus » 2023-06-08 08:49:30

I'll look into the compiler again, and thank you.

#17 Re: mORMot 1 » ISQLDBRows always causes memory leaks in lazarus » 2023-06-08 07:35:46

this is  my code :

var
  stmt: ISQLDBRows;
  oledbP: TOleDBMSSQLConnectionProperties;
begin
   oledbP := TOleDBMSSQLConnectionProperties.Create(oleServer, oleDB, oleUser, olePwd);
  try
    stmt := oledbP.Execute('select * from test ', []);
    while stmt.Step do
    begin
      //do something
    end;
  finally
    stmt.ReleaseRows;
    stmt := nil;  -------> call   memory leaks   (Use Heaptrc Unit check for mem-leaks)(-gh)
    oledbP.Free;
  end;
end; 

lazarus --2.2.0
fpc --3.2.2

#18 mORMot 1 » ISQLDBRows always causes memory leaks in lazarus » 2023-06-08 01:17:36

zhangguichao
Replies: 4

ISQLDBRows always causes memory leaks in lazarus(fpc3.2.2)

When executed
The ReleaseRows method  and then set it to nil  sad

#22 mORMot 2 » Does SynMongoDB support transactions? I didn't find it » 2023-04-25 03:43:07

zhangguichao
Replies: 2

Does SynMongoDB support transactions? I didn't find it?

#24 Re: mORMot 2 » with mormot+sqlite can i set Isolation level ? » 2023-04-20 06:54:12

In this case, do I have to use transactions?

(for Some concurrent modification operations...)

#26 mORMot 2 » with mormot+sqlite can i set Isolation level ? » 2023-04-20 03:34:36

zhangguichao
Replies: 5

with  mormot+sqlite  can i set  Isolation level ?
for Some concurrent modification operations...

#28 Re: mORMot 2 » Ask questions » 2023-04-19 00:56:11

Thank you very much for your answer

#29 mORMot 2 » Ask questions » 2023-04-18 09:03:18

zhangguichao
Replies: 4

Are there actual cases of big data volume and concurrency?

I am very interested in this framework, usually use mssql, I don't know if I can switch to mormot+sqlite

Thanks for  answer ?

Board footer

Powered by FluxBB