hi all, I'm having trouble with the performance of my select queries. The database has around 121,000 records and data retrial is very slow is there way around this? maybe if i store the whole table in RAM(Data set)? would that be more efficient? and if so any pro's or con's?
thanks for your time.