This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have several .yxdb files that I’ve been appending to daily from a SQL Server table in order to extend the length of time that data is retained.
They’re massive tables, but I may only need one or two rows.
I had hoped to decrease the time it takes to get data from them by running a query on them (or a dynamic query/input) as opposed to using a filter or joining on an existing data set which would have equal values that would produce the same result as a filter.
Essentially, the input of .yxdb would have the option of inputting the full table or a SQL query just like a data connection.