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

    Performance of querying a txt file Vs excel file

    rakeshsagar

      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

        • 1. Re: Performance of querying a txt file Vs excel file
          rareddy

          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..