Our product is an ERP program that often automatically generates many queries based on Metadata, some of which may contain very many query columns, perhaps 700+. The actual number of data rows returned is not much, about more than 1500, but it takes 15 seconds, how should this situation be optimized? ps: More than 700 columns may all be necessary for the business and cannot be cut down significantly
3