1. Hugh is now back at work, more or less full time, after a slower than expected recovery from his neck surgery early this month. Obviously we have a backlog of support to clear, and are working as hard as we can to take care of it. If you have an unanswered thread more than 3 days old, please post one (and only one) "bump" on it, to move it in to our "last 3 days" list. If you have an unanswered issue in a forum you no longer have access to due to subscriptions timing out, please use the Contact Us form, and provide us with the URL to the thread.

Map And Database In One Web Site

Discussion in 'Community' started by cypherinfo, Jul 14, 2012.

  1. cypherinfo Member

    Level: Community
    Hello, it is more than a while I do not visit this forum. I'd like to know how it is possible to build a web site over a database that may run web search and display on a google map the results of database query.

    I wonder if and how farbik may be of some help.


    Thank you.
  2. cheesegrits Support Gopher

    Level: Community
    hard to know exactly from that description, but yes - we allow you to build lists based on tables, with Google map elements, and we have a filterable Google map visualization for displaying a filtered version of the table data on a single map.

    -- hugh
  3. cypherinfo Member

    Level: Community
    Thank you for your reply. The idea is similar to this: http://livelovely.com/search
    Hopely to add a dropdown or an advanced search boc instead.
    Same layout and content.

    Thank you.
  4. cheesegrits Support Gopher

    Level: Community
    Yes, we can do something very similar to that, with additional search filters in a box above the map.

    -- hugh
  5. cypherinfo Member

    Level: Community
    I always used Fabrik with table of thousands records max. I wonder if its performances are the same for my project with one million and an half of records.

    Thank you.
  6. cypherinfo Member

    Level: Community
    Is there anybody who already test Fabrik with table with more than 1 million of records please?

    Thank you.
  7. cheesegrits Support Gopher

    Level: Community
    Yes, we've had several folk use Fabrik on tables of that size.

    Theoretically, it should work just fine. Obviously MySQL itself is going to grind a bit slower with that many records, but Fabrik is very careful never to do "unconstrained" SELECT queries, and we handle creating indexes automatically for anything you use as element filters, etc.

    Having said that, you may run across some issues, and certain things like using the "search all" feature, which will search on non-indexed fields, would probably not work, or at least be horribly slow. But if you do run across any unanticipated issues, I'm fairly sure we could overcome them.

    -- hugh

Share This Page