Database Read Action

How to select specific fields in the ChronoForms Database Read Action.

Overview

The default behavior reads all fields, which can be inefficient when only a few columns are needed, especially from large tables.
Use the Query Fields option in the Advanced Settings to specify only the required fields, improving query performance and control over displayed data.

rb rbock 11 May, 2023

How can I use only certain fields in the Database Read Action?

Max_admin 11 May, 2023

Answer

Read Data > Advanced Settings > Query Fields

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

rb rbock 11 May, 2023

New Field = id | Field Alias = idddd
New Field = stamp | Field Alias = stampppp

It's ok, but on debug page:

SELECT `data`.`id` AS `data.iddd`, `data`.`stamp` AS `data.stamppp`,..., `data`.`name` AS `data.name`,...

name is not set on query fields

Max_admin 11 May, 2023

ok, why do you need to choose fields ? let it read all fields, that is the default behavior

Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.

rb rbock 11 May, 2023

I have tables with 30 fields. Some of them text with 2500 - 5000 characters. In lists I only need 5 fields, in the detail pages about 20. Some fields should not be used in the list or in the detail page.

we webbusteruk 11 May, 2023

1 Likes

Being able to SELECT specific columns is better than only able to SELECT all.

https://weblogs.asp.net/jongalloway/the-real-reason-select-queries-are-bad-index-coverage

This topic is locked and no more replies can be posted.