I have database, Visual basic as front end, and sql server as backend, the reports are using crystal report. Recently, the user complain it is too slow to run, it took a long to load the data, anybody help me? Thanks in advance.
It is sometime very slow. I will check these you posted as this system was design by somebody else. I had question, can this sql server perfome slower in some case that is not relation to design that you said? I want to make sure it is not sql server problem. So i will only check the design. Thanks.