Re: user constructed where clause

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: user constructed where clause
Дата
Msg-id CAKFQuwY1Ep2gDE3B2cWZkK4pDgMm-stG9f340m1HVoHB9sMifw@mail.gmail.com
обсуждение исходный текст
Ответ на user constructed where clause  ("Yelai, Ramkumar IN BLR STS" <ramkumar.yelai@siemens.com>)
Ответы Re: user constructed where clause  ("Yelai, Ramkumar IN BLR STS" <ramkumar.yelai@siemens.com>)
Список pgsql-general
On Tue, Jun 9, 2015 at 4:48 AM, Yelai, Ramkumar IN BLR STS <ramkumar.yelai@siemens.com> wrote:
Now, the requirement is if user provides filter information based on every column from the web UI, this filter will let the user construct the “where clause” and provide to postgresql.
In a month this table exceeds millions of record. If  I use the user-constructed query then it would take lot of time as the user may not include indexed column in the user-constructed query.

​The first solution that comes to mind is to construct a document containing the relevant information, index that, and then provide a single search input field that is used to construct a text search query that you apply against the indexed document.

In short, forget the fact that there are fields and just index and search the content.

Add additional controls to the UI for just those fields that are indexed.

David J.
 

В списке pgsql-general по дате отправления:

Предыдущее
От: "Yelai, Ramkumar IN BLR STS"
Дата:
Сообщение: user constructed where clause
Следующее
От: Bruce Momjian
Дата:
Сообщение: The purpose of the core team