[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: SQLite for temp tables

  • Thread starter Thread starter frank.meulblok
  • Start date Start date
Status
Not open for further replies.
F

frank.meulblok

Guest
Also a quick reminder: Temp-tables have their own buffer pool, which you can size with the -Bt & -tmpbsize parameters. That defaults to 255 blocks of 4k, so that's 4k short of a megabyte. If you are going to cache large-ish sets of data in temp-tables, you really want to increase that by a large margin.

Continue reading...
 
Status
Not open for further replies.
Back
Top