Query or Direct File Access based Web application

Startbeitrag von Diego Sanchez.pcs.crosspost am 22.04.2013 13:18

Hi, I have been developing a mid sized Web app that will be used by 150+ users from different places with varying internet speeds ranging from 2mbps ADSL to 4mbps Simmetric on a daily basis, all my tables are query based because my main concern is speed and my experience in other languages using filters has been terrible.

Does anyone else have had any ( good-bad )experience on using tables with direct access and filters?

TIA

Message forwarded from pcsoft.us.windev

Antworten:

Hi Diego

it always depend of a lot of parameters, but consider this (very
theoretical, you would need to do some testing)...

when using a table based on a file with a hfilter, ONLY the VISIBLE
records are read from the file and send to the browser (Not true if
preloading all records in the table, of course, but we are talking about
optimization, here)

When using a query, the whole query has to (or may have to, depending on
the query) be calculated, then only the visible records are loaded in
the table...

So when you are accessing a DB via the network, the query solution may
be faster (less traffic) or slower (more data access)

However, on a web server, the DB is often on the same machine as the web
server, so there is no netxwork traffic for the data access. In this
case, you end up with more disk access in the query solution, and
everything else is basically the same, so the hfilter/direct file should
be faster...

Furthermore, the number of record to be displayed is also important...
if the query is returning only a few records (ie only a few pages of
data, as displayed in the table), the difference in time will be
negligible. On the contrary, if the query contains thousands of record,
using a a direct file table should not only be faster for your user, but
also reduce the data access load and add speed to your other
simultaneous users.

Now, on a web site, optimization has very often nothing to do with data
access, and much more in page weight, as the transfer time between
server and browser is very often much bigger than the data access time

Best regards


--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

More information on http://www.fabriceharari.com


On 4/22/2013 10:18 AM, Diego Sanchez wrote:
> Hi, I have been developing a mid sized Web app that will be used by 150+ users from different places with varying internet speeds ranging from 2mbps ADSL to 4mbps Simmetric on a daily basis, all my tables are query based because my main concern is speed and my experience in other languages using filters has been terrible.
>
> Does anyone else have had any ( good-bad )experience on using tables with direct access and filters?
>
> TIA
>
Message forwarded from pcsoft.us.windev

von Fabrice Harari.pcs.crosspost - am 22.04.2013 14:08
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.