Selective access to SQL data

Discussion in 'Pre-Sales Questions' started by josuzy, Oct 28, 2011.

  1. josuzy

    josuzy New Member

    Joined:
    Oct 28, 2011
    Messages:
    1
    Hi guys, hoping someone can suggest the most elegant solution to my requirement. I want to give my subscribers access to one or more groups of records held on an SQL database, and displayed on a web page (using JGrid). The database is not (and cannot be) hosted on my web server. The database content refreshes every 30 seconds, and users always want to see the latest data.

    The selection of the database records will be based on a 3-digit field, which can have about 30 different values.

    I suppose I could create 30 different URLs and control access to these URLs with amember. However, this doesn't strike me as a smart solution, not least because it would create a huge strain on the bandwidth of my database server.

    Can anyone suggest a smarter way of doing this?

Share This Page