New Database Design in Pro available?

WordPress Event Management, Calendars & Registration › Forums › Pre Sales Questions › New Database Design in Pro available?

This topic contains 1 reply, has 2 voices, and was last updated by  Stephen Harris 9 years, 2 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • November 11, 2015 at 9:05 pm #19928 Reply

    If I be a weekly entries recurring appointment, then this entry will have repeated so often as I indicated in the database as a whole time.
    Is it for the performance of the Database is not better to introduce a further index for Recurring appointments and to mark this special.

    Over 50 entries in the databse of one Entries, who repeats itself every week …

    Maybe an idea 😉

    Fabi
    November 12, 2015 at 12:08 am #19930 Reply

    Hi Fabi,

    Could you explain your proposal more? I consider the current design to be the most performant possible, but I’m willing to be challenged on that.

    To summarise, each event (recurring or otherwise) is one entry in the wp_posts table. Each event is then linked to one or more dates in the wp_eo_events table. Each record in that table has an ID as a primary column, and indexes on the start and end date/time columns.

    How does your proposal differ from that? And what index do you propose for recurring events?

    Thanks,

    Stephen Harris
  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: New Database Design in Pro available?
Your information:




To create code blocks or other preformatted text, indent by four spaces:

    This will be displayed in a monospaced font. The first four 
    spaces will be stripped off, but all other whitespace
    will be preserved.
    
    Markdown is turned off in code blocks:
     [This is not a link](http://example.com)

To create not a block, but an inline code span, use backticks: 

Here is some inline `code`.

For more help see http://daringfireball.net/projects/markdown/syntax


<a href="" title="" rel=""> <blockquote cite=""> <code> <pre> <em> <strong> <del datetime=""> <ul> <ol start=""> <li> <img src="" border="" alt="" height="" width=""> <p style=""> <span style="">