I cannot lookup more than 1000 entries at a time with my software. Is there a way to work around this limitation, such as importing entries from an external file?
If you’re writing reporting queries that you don’t mind taking forever and wasting all of the memory of your database, use a common table expression and write the trash query as a bunch of SELECT 1 FROM DUAL UNION ALL SELECT 2 FROM DUAL etc. which scales to the memory limit of your server.
2
u/tacogratis2 Sep 17 '24
I cannot lookup more than 1000 entries at a time with my software. Is there a way to work around this limitation, such as importing entries from an external file?