Jdbc input, its really necessary to order the results ascending?

Elastic Stack Logstash
1

hi, im getting data from a postgregs db, the tracking column that im using is unix epoch called clock this is part of my conf:

  input{                            
                "...other parameters...
                and clock > :sql_last_value
                order by clock asc"
                schedule => "*/30 * * * *"
                use_column_value => true
                record_last_run => true
                tracking_column => "clock"
}

I was wandering if its really necessary to order the results ascending, because it takes to long when I use order by....what will be the problem if I dont use order by?

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.