Dataview Loading Time Issue

Suite and Optimus Suite 5
#1

Hi,
I am using Dataview and it works great. However, as my record size grows, the initial loading time is very large, even with Pagination. I looked at the log file and it seems like the query SELECT COUNT(*) as DHX_COUNT is taking a lot of time, sometimes excess of 10-15 seconds (i have million+ records).

How can i solve this issue? I could store the record count in a separate table … but what modification can i make to the framework to make this change? Any other inputs?

Thanks.

#2

Hi,

SELECT COUNT(*) as DHX_COUNT query is executed fast if a table has indexes. What db are you using ?

#3

mysql 5.1.49

#4

Hi,

are you using indexes in a table? If they are set, this command is executed very fast even for the table that contains million records.

#5

Thanks for your help. I do not think i have been using INDEX.
I will try that out. Thanks for your help.

#6

I have many columns ~10 in the table.
Do i need to INDEX all the columns or just the Primary Key column?

#7

Hi,

Do i need to INDEX all the columns or just the Primary Key column?

Primary key will be enough.