# Logstash output Performance

**URL:** <https://discuss.elastic.co/t/logstash-output-performance/71181>\
**Category:** Logstash\
**Created:** [January 11, 2017, 7:20am UTC](https://discuss.elastic.co/t/logstash-output-performance/71181 "2017-01-11T07:20:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ElsayedAwd](https://avatars.discourse-cdn.com/v4/letter/e/da6949/32.png) [@ElsayedAwd](https://discuss.elastic.co/u/ElsayedAwd)\
**Post date:** [January 11, 2017, 7:20am UTC](https://discuss.elastic.co/t/logstash-output-performance/71181/1 "2017-01-11T07:20:42Z")

</div>

I 'am using Elasticsearch 5.1.1 , logstash 5.1.1 ,I imported 3 millions rows from sqlserver into elastic via logstash in **2 hours**

I have 1 single windows machine with 4GB Ram , core I 3 🙂 is there any additional configurations should I add to speed up the importing ?

## Logstash Configurations

> input {  
> jdbc {  
> jdbc\_driver\_library =\> "D:\Usefull\_Jars\sqljdbc4-4.0.jar"  
> jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
> jdbc\_connection\_string =\> "jdbc:sqlserver://192.168.5.14:1433;databaseName=DataSource;integratedSecurity=false;user= **;password=** ;"  
> jdbc\_user =\> "**"  
> jdbc\_password =\> "**"  
> statement =\> "SELECT \* FROM RawData"  
> jdbc\_fetch\_size =\> 1000  
> }  
> }  
> output {  
> elasticsearch {  
> hosts =\> "localhost"  
> index =\> "testdata"  
> document\_type =\> "testfeed"  
> document\_id =\> "%{id}"  
> flush\_size =\> 512  
> }  
> }

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [February 8, 2017, 7:21am UTC](https://discuss.elastic.co/t/logstash-output-performance/71181/2 "2017-02-08T07:21:09Z")

</div>

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