FirePHP not returning ajax request queries, yet returns normal page load queries


HOME ยป Web Design

I am using firePHP(Zend profiler) on on FF 3.6.3(firephp addon
installed) and it returns queries, when I do a normal page load. Ajax
requests, however, are not returning the proper queries. I am using
Prototype 1.6.0.2 for ajax requests. Is there something I am missing?
Most of the write-ups seem to imply that this should work by
default.

I use this query to fetch the ID of the Next and Previous Events in
a mysql events table:


SELECT e.id AS current, prev.id
AS previous, next.id AS next
FROM events e
CROSS JOIN />(
SELECT id FROM events
WHERE date <
'{$result['date']}'
ORDER BY date DESC
LIMIT 1 />) prev
CROSS JOIN
(
SELECT id
FROM
events
WHERE date > '{$result['date']}'
ORDER
BY date
LIMIT 1
) next
WHERE e.date =
'{$result['date']}'

This query works fine.

/>

lets pretend the table looks like so:


Databases

I am using firePHP(Zend profiler) on on FF 3.6.3(firephp addon
installed) and it returns queries, when I do a normal page load. Ajax
requests, however, are not returning the proper queries. I am using
Prototype 1.6.0.2 for ajax requests. Is there something I am missing?
Most of the write-ups seem to imply that this should work by
default.

Web Design

I need to know how many sql queries are being executed per page
request. As the site is already done and I am just running
optimization analysis, I would prefer if any solution offered doesnt
require that i change the entire website structure.


I use
a single connection to send all queries to the MySQL database:

/>define('DATABASE_SERVER', '127.0.0.1'); />define('DATABASE_NAME', 'foco');
define('DATABASE_USERNAME',
'root');
define('DATABASE_PASSWORD', ');
$DB_CONNECTION =
new mysqli(
DATABASE_SERVER,
DATABASE_USERNAME, /> DATABASE_PASSWORD,
DATABASE_NAME,
3306 />);
Programming Languages

I need to host a WCF Data service as part of a legacy ASP.NET MVC
website running in IIS 7 Integrated mode.


Read access to
the web service is working fine, but whenever I try to POST to the web
service, I get a 400 Bad Request error.


For testing
purposes, I have downloaded the sample odata service from
http://www.odata.org/developers/odata-sdk#/media/7582/odatasampleservices.zip.
Posting to that webservice works fine when running it in a separate
IIS website. However, when I put it in my legacy website, I am geting
that 400 Bad Request error wen sending a post request to the service
again.


Therefore the problem seems to be relat

Programming Languages

To optimize application speed, everyone always advises to minimize
the number of queries an application makes to the database,
consolidating them into fewer queries that retrieve more wherever
possible.


However, this also always comes with the caution
that data transferred is still data transferred, and just because you
are making fewer queries doesn't make the data transferred
free.


I'm in a situation where I can over-include on the
query in order to cut down the number of queries, and simply remove
the unwanted data in the application code.


Is there any
type of a rule of thumb on how much of a cost there is to each query,
to kn

Coding
The front page of my website's info is: Took 0.17 seconds and 7.25MB
of RAM; Used 108 files and 38 queries; Sent 56 events; 0 cache hits
and 0 missesAnd another popular page: Took 0.30 seconds and 7.25MB of
RAM; Used 108 files and 79 queries; Sent 75 events; 0 cache hits and
0 misses;Are these numbers normal?What would be the recommended
amounts for these numbers.
Programming Languages

- Technology - Languages
+ Webmasters
+ Development
+ Development Tools
+ Internet
+ Mobile Programming
+ Linux
+ Unix
+ Apple
+ Ubuntu
+ Mobile & Tablets
+ Databases
+ Android
+ Network & Servers
+ Operating Systems
+ Coding
+ Design Software
+ Web Development
+ Game Development
+ Access
+ Excel
+ Web Design
+ Web Hosting
+ Web Site Reviews
+ Domain Name
+ Information Security
+ Software
+ Computers
+ Electronics
+ Hardware
+ Windows
+ PHP
+ ASP/ASP.Net
+ C/C++/C#
+ VB/VB.Net
+ JAVA
+ Javascript
+ Programming
Privacy Policy - Copyrights Notice - Feedback - Report Violation 2018 © BigHow