- تاریخ ثبتنام
- 2020-06-26
- نوشتهها
- 21,417
- راهحلها
- 27
- پسندها
- 3,264
- امتیازها
- 113
- سن
- 27
- محل سکونت
- England
- وب سایت
- xenforo.xyz
Can someone please tell me what and how I can do this to minimize the queries:
I am building a class that outputs a page. I fetch the titles of ten threads and then the individual posts from those threads.
These ten threads and posts are almost never changed.
My query looks something like this:
a) 1 query: Fetch threads with thread_id in [1...10]
b) 10 queries: Fetch posts from the individual threads
(Yes, could do this in one go, but I need an example to save a lot of queries)
So...
I am building a class that outputs a page. I fetch the titles of ten threads and then the individual posts from those threads.
These ten threads and posts are almost never changed.
My query looks something like this:
a) 1 query: Fetch threads with thread_id in [1...10]
b) 10 queries: Fetch posts from the individual threads
(Yes, could do this in one go, but I need an example to save a lot of queries)
So...
نام موضوع : Reducing Queries to one?
