Agfdhyk

Hi I want to use fullcalendar with a database its works but as soon as I put more than 10k events in the calendar it stops showing events.
Is there a way to stop fullcalendar from stopping to show events?

The version below is 4.0.0

(I used both 3.9.0 and 4.0.0 of fullcalendar both are not working)

<script type="text/javascript">

    document.addEventListener('DOMContentLoaded', function () { // DOMContentLoaded zorgt ervoor dat eerst de html laad

        var calendarEl = document.getElementById('calendar'); // grab element reference



        var calendar = new FullCalendar.Calendar(calendarEl, {

            // put your options and callbacks here

            events: [

                <?php



                include_once('./assets/handlers/DB_Handler.php');



                try {

                    $getCalenderItems = $conn->prepare("SELECT COD.CursusID, O.Onderdeelnaam,

                    CONCAT( REPLACE( DATE_ADD( DATE( CO.DatumBegin ) , INTERVAL -1 MONTH ) ,  '-',  ',' ) ,  ',', HOUR( CO.DatumBegin ) ,  ',', MINUTE( CO.DatumBegin ) ) AS Start,

                    CONCAT( REPLACE( DATE_ADD( DATE( CO.DatumEind ) , INTERVAL -1 MONTH ) ,  '-',  ',' ) ,  ',', HOUR( CO.DatumEind ) ,  ',', MINUTE( CO.DatumEind ) ) AS Eind



                    FROM cursusonderdeeldocenten COD



                    INNER JOIN onderdelen O ON COD.OnderdeelID = O.OnderdeelID

                    INNER JOIN cursusonderdelen CO ON COD.CursusID = CO.CursusID



                    WHERE COD.DocentID = 15

                    AND CO.DatumBegin >=  DATE_ADD(CURDATE(), INTERVAL -8 MONTH)

                    ORDER BY CO.DatumBegin");



                    $getCalenderItems->bindParam(':DocentID', $DiD);



                    // Select docent

                    $DiD = 15;

                    $getCalenderItems->execute();

                    $count = $getCalenderItems->rowCount();



                } catch (PDOException $e) {

                    $e->getMessage();

                }



                $i = 0;



                while ($row = $getCalenderItems->fetch()) {



                    echo '

                                                        {

                                                        title: "' . $row['Onderdeelnaam'] . '",

                                                        start: new Date(' . $row['Start'] . '),

                                                        end: new Date(' . $row['Eind'] . '),

                                                        url: "./beoordelen/' . $row['CursusID'] . '"

                                                        }';



                    if ($i >= $count) {

                        echo "";

                    } else {

                        echo ",";

                    }



                    $i++;

                }



                ?>

            ]

        });



        calendar.render();

    });

</script>

<div id='calendar'></div>





</div>

I added 3k+ events to my calendar and it works fine. You can check my code here.

Could you check the browser console to see if there is an error?

The version that I use is 3.9.0.