<div>
It depends. &nbsp;In-line TVFs are extremely efficient and will scale nicely. &nbsp;Multi-line TVFs are inefficient and will not scale well at all.<br />
<br />
I have no idea for MySQL.
</div>


It depends.  In-line TVFs are extremely efficient and will scale nicely.  Multi-line TVFs are inefficient and will not scale well at all.

I have no idea for MySQL.

<div>
I was unaware that stored procs using table functions would not cache. I will post again to try to find my options in MySQL.
</div>


I was unaware that stored procs using table functions would not cache. I will post again to try to find my options in MySQL.

<div>
<div class="content wysiwyg-content">
I have an application that groups orders in many different ways (by company, store, warehouse, account). I have used a MS SQL table function to gather the appropriate account IDs and join that table function to my primary order table to make sure the user is exposed to the appropriate orders. This has worked well as it saves me from have to have 20 variations of every select stored proc in the application but I have two questions - <br />
<br />
Is this scale-able if the database grows up to 50 million rows in the order table?<br />
<br />
Is there a way to do this in MySQL?
</div>
</div>


I have an application that groups orders in many different ways (by company, store, warehouse, account). I have used a MS SQL table function to gather the appropriate account IDs and join that table function to my primary order table to make sure the user is exposed to the appropriate orders. This has worked well as it saves me from have to have 20 variations of every select stored proc in the application but I have two questions - 

Is this scale-able if the database grows up to 50 million rows in the order table?

Is there a way to do this in MySQL?

SQL Table Functions -  do they scale well, is there an efficient way to emulate them in MySQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.