Em Andamento

Optimize sql query

I am using fuelphp ([url removed, login to view]) as a framework and I am stuck on a certain sql query

Currently I want to retrieve paginated data (with limit and offset) with the addition of the total number of objects available

Currently it gets total number of entries and with this count it uses to dynamically generate the offset/limit for the data fetch

I want to be able to get all the results from one single query.

Please see attached a snippet of the fuelphp code to do the two queries (I want to combine them) This is just the snippet with the info that is needed.

I want to combine the two queries into one.

Habilidades: MySQL, SQL

Ver mais: sql query, fuelphp, optimize sql queries, mysql number sql, sql optimize, fetch mysql, mysql fetch, mysql combine, 2013 query, count objects, fetch results, queries sql, optimize code, query optimize, query combine, mysql objects, query optimize mysql, mysql queries using, data fetch, generate query, mysql optimize, optimize query mysql, mysql optimize query, optimize mysql query, optimize count query

Acerca do Empregador:
( 84 comentários ) Te Awamutu, New Zealand

ID do Projeto: #5145614

Premiar a:

elboukharimu

Hi, I'm very interested helping you resolving your sql query, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some sampl Mais

$70 USD em 1 dia
(14 Avaliações)
4.3

5 freelancers estão ofertando em média $58 para este trabalho

kchg

Hello, sir I'm interested with your project. I'll do it for you. I can do it well more than you could guess. :) Regards.

$70 USD em 1 dia
(51 Comentários)
5.7
jaisnikhil

Hi There! I can do it for you. Thanks

$54 USD em 1 dia
(14 Comentários)
4.4
Dzintars

Hello! I am more than 4 years experienced with Mysql and SQL developer, more than 2-3 years PHP OOP developer and so I am interesting into Your offered project and I want to complete this job. Little about me Mais

$70 USD in 3 dias
(0 Comentários)
0.0
trignesh

Hi I can provide you a single query with pagination. I have did this kind of work in web application previously. If you are available to talk reply me immediate

$25 USD em 1 dia
(0 Comentários)
0.0