1 Reply Latest reply on Apr 21, 2014 9:24 AM by Ramesh Reddy

    Performance of querying a txt file Vs excel file

    Rakesh Balguri Expert
    Rakesh Balguri Apr 21, 2014 1:37 AM

      Hi,

       

      We have been using .txt files as our datasources for our requirement.

      Now that Teiid 8.7 provides support for reading the excel files, we would like to use this feature.

      But before using this feature we would like to know the performance of both the data sources.

       

      Can you comment on the performance of querying a txt file Vs excel file with the same content in both files?

       

      Thanks

      Rakesh

      • 53 Views
      • Tags:
        • 1. Re: Performance of querying a txt file Vs excel file
          Ramesh Reddy Master
          Ramesh Reddy Apr 21, 2014 9:24 AM (in response to Rakesh Balguri)

          There is *no* performance information available. Let us know what you find out.

           

          I would say text file would be still faster with larger documents, as Excel translator uses POI to load the whole document in memory before returning the results. No streaming support yet, thus working with very large documents is still an issue to be solved. Where as csv files have been tested prior with very large sizes.

           

          Ramesh..