Re: DB design advice
От | Toni Alfirević |
---|---|
Тема | Re: DB design advice |
Дата | |
Msg-id | C8800CE0-51C9-45B9-9C01-055424BFF2C6@gmail.com обсуждение исходный текст |
Ответ на | Re: DB design advice (Sergey Konoplev <gray.ru@gmail.com>) |
Ответы |
Re: DB design advice
|
Список | pgsql-novice |
On 7. 6. 2013., at 07:39, Sergey Konoplev <gray.ru@gmail.com> wrote: > On Thu, Jun 6, 2013 at 2:29 AM, Toni Alfirević <toni.alfirevic@gmail.com> wrote: >> And app should allow user to search trough his logs filtered by one or more >> tags and time interval. Here is one more constraint, since those messages > > Is it supposed to return all the data from this interval at once, or > to be implemented like a kind of pagination/slider, that gets a > limited amount of entries since the beginning of the interval, and > then, after user requested more, it gets entries that are after the > last one from the previous bunch, and so on? Hi Sergey, It will most likely return subsets of data just like you said (pagination). But there will be a situation where all data will need to be analyzed for, let's call it', a report. On the other hands thosereports are not that sensitive when it comes to performance. It won't be an issue if it takes a minute, two or threeto generate it.
В списке pgsql-novice по дате отправления: