MetaMatrix Text File Connector hangs when using a large data file
Issue
- We have created a model for a text file data source and the text file has 90,000 records and 98 columns.
- I ran the query in the MetaMatrix Designer and it is taking forever to return results from this file. If I use a LIMIT 16000 clause, it returns 16000 records. But if I add even 16001, it is not returning results and keeps running so I have to cancel the query.
Environment
- MetaMatrix Enterprise Server 5.5.4
- MetaMatrix Enterprise Designer 5.5.4
- MetaMatrix Text File Connector 5.5.4
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.