Recent

Author Topic: [Solved] Are there any limits on query results?  (Read 1179 times)

Zvoni

  • Hero Member
  • *****
  • Posts: 1339
Re: Are there any limits on query results?
« Reply #15 on: June 30, 2022, 10:52:21 am »
In fact, the number of records is not very many, only 243. But in each record, there are 7 columns to store 'bytea' type documents. On average, files between 1 Mb and 7 Mb are stored. Some may be empty. But 7 Mb recording is available in all of them.
7Mb or 7MB(x243)? Because if the latter, then you are dangerously approaching the border of 32-bit systems

Michał
And now you know, why you should pull BLOBS only if user requests it.....
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad

loaded

  • Hero Member
  • *****
  • Posts: 602
Re: Are there any limits on query results?
« Reply #16 on: June 30, 2022, 05:30:03 pm »
7Mb or 7MB(x243)? Because if the latter, then you are dangerously approaching the border of 32-bit systems
Thank you very much for your warning miab3


And now you know, why you should pull BLOBS only if user requests it.....
Experience is something else ...   8)
If Ide=Lazarus 2.0.10 32 Bit and Os=Win 10 Home 64 Bit then Get up and do something useful! Because God is the helper of those who start again;

 

TinyPortal © 2005-2018