What is faster?
| От | Ioannis Anagnostopoulos |
|---|---|
| Тема | What is faster? |
| Дата | |
| Msg-id | 4EE0B421.7070100@anatec.com обсуждение исходный текст |
| Ответ на | Re: Basic Query Question (Jude Lucien <jlucien@gmail.com>) |
| Список | pgsql-novice |
Hello all, This time I am moving to something more advanced than assuming bugs that they don't exist. I am creating a stored procedure that accepts 2 inputs and should return many record (by record(s) I mean "set of...."). I have notice however that there are many ways to achieve this and given my 22million rows I need the faster solution. So what my SP should return? 1. A refcursor? 2. A setof Records with record fields declared as OUT in the parameters? 3. A setof records with the record type explicitly declared in my schema? Not sure If I have exhausted all the option. Your advice will be much appreciated. The basic select is happening in a single table. Kind Regards Yiannis
В списке pgsql-novice по дате отправления: