Recent

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

Zvoni

  • Hero Member
  • *****
  • Posts: 2319
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: 824
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)
Check out  loaded on Strava
https://www.strava.com/athletes/109391137

 

TinyPortal © 2005-2018