We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Paging on search GUI — Vertica Forum

Paging on search GUI

We are using flex tables on vertica with couple of materialized columns and __raw__ column and we are about to develop a web based search GUI for vertica. The problem we faced is to divide the huge search result into multiple pages. Vertica returns whole result to web server which causes web server to crash. Is there a function or method to pull the result set in chunks of for example 500 rows, and then next 500 rows?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
You can use Markdown in your post.