Announcement

Announcement Module
Collapse
No announcement yet.

Performance of a database with a lot of tables

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    Thanks for the replies.

    Continuing talking about using views, would it produce a lot of overhead in comparison with adding the proper condition to queries in the application, like:


    select post_id, post_title from posts where post_id = 5 and user_id = 7

    ?

    Are there any side effects I should consider when using views?

    Comment


    • #17
      I guess you need to test it.

      Your views are going to be simple and so they should basically do same rewrite as you're mentioning. If it is enough I would fix the application though.

      Comment


      • #18
        Is there a way to make MySQL set user_id automatically when I perform an insert to username_tablename (it is a view on tablename)?

        Comment

        Working...
        X