very slow loading of leads

[livewire]

Hi

I have around 100,000 leads in my CRM.. When i try to load these it takes like 20-30 seconds to load and most of the time it time outs..

It happens only when loading the leads page.. Other than that everything else works fine

Im using version 4.5

Any help on this will be appreciated


Thanks

[tanya]

What php version do you use?
Also you could uncheck the box Display Total Count (on List View) in Administration > User Interface

[livewire]

Im using php 5.6

I disabled the display count.. Still the same

Im showing 20 leads per page. When i click on show more it takes the same amount of time and most of the time, it time out

[livewire]

This is the url which gets the leads i guess "api/v1/Lead?maxSize=15&offset=0&sortBy=createdAt&asc=fals e"

I tried reducing the it to show 15 leads per page... I dont see any improvement.

[tanya]

Is this problem only with leads? Could you check lead indexes in database?