Hi All,
In my data model have master table and transaction table, here master table linked to transaction with ids but some ids are not available to transaction level so this will effect on performance.
Example 1: Master table have 100 records and transaction table have 80 records here linked to only 80 records only remaining 20 records are empty my question is this will effect on performance, If effect then how to improve performance.
Date format issue.
Example 2: In my data model have several DVDs and Excel file extracting and date have different formats like
(i). 09/03/2015 (date only) and (ii).09/03/2015 12:00:00(Date with time-stamp) So i have changed date format , but my Question is this will effect on performance, If effect could you please help me how to avoid those things.
In front-end (Dashboard) level what should i do for improving the performance can give me tips.
Please suggest to me all above quires.
Advance Thanks,
Munna
