Database Indexes

[phlunk3]

I am fairly new to using the system so please dont laugh :P

I am curious as to wether indexes on my MySQL table will have any effect on the time required to show views or reports in jasper, in effect, I guess my question is, does jasper actually read directly from the MySQL table more than to just create an index itself of the data?

[anandharaj]

Well, i do not understand your question exactly. Some of the data do have the Indexes (you also can create if required). Those Indexes are to speed up the process "searching" / "accessing" the data. Is this clear?

[phlunk3]

I am aware how the indexes work/help in a database, however I am asking IF the data is continuously accessed from my MySQL database by the OLAP system, or if it is just pulled once and help in the OLAP servers memory system?

 

Thank you for your reply :)

[anandharaj]

JS do keep the data in memory.

[ramnik]

In jasperserver-pro 3.5, however , there is feature either to read the data in memory or push the data processing to database ..user can select that optionbefore creating reports ..under manage adhoc options ..

[jens_noering]

In everyway JS has to load the data from the database (datasource).

So setting indexes will have an effect on the time that is required to show a view or a report.

JS generates an sql- statement and pushes this to the underlying database, so you will have to optimize the underlying database structure.

 

hth, jens