Comments by Joe Stansfield (Top 2 by date)

Joe Stansfield 17-Sep-14 5:15am View

Thankyou!
Something very simple (no where clause!). So that was resulting in the entire table being returned all the time, but just the relevant rows been displayed through the joined tables.

Now it runs like a dream!!

Joe Stansfield 16-Sep-14 21:46pm View

Thanks,

I will look in to that.

I have also read that creating a view may improve performance, however people seem conflicted on this. Would creating a view between the 2 tables that contain all the columns I require be likely to improve things?

Joe

Advertise
Privacy
Cookies
Terms of Use
Last Updated 1 Jan 1900

Layout: fixed | fluid