What takes more computing power, serving HTTP or MySQL?

What takes more computing power, serving HTTP or MySQL?
by

1 Answer

Answer :

this is not exactly my field, but i would say http has much more to do that mysql. with http you are loading everything, where mysql is just loading data. i guess it could depend on the site and whats on it, but for the most part http will be doing most the work.
by

Related questions

Point out the wrong statement. a) Atom is a syndication format that allows for HTTP protocols to create and update information b) Cloud services span the gamut of computer applications c) The impact of cloud computing on network communication is to discourage the use of open-network protocols in place of proprietary protocols d) None of the mentioned

Description : Point out the wrong statement. a) Atom is a syndication format that allows for HTTP protocols to create and update information b) Cloud services span the gamut of computer applications c) ... discourage the use of open-network protocols in place of proprietary protocols d) None of the mentioned

Last Answer : The impact of cloud computing on network communication is to discourage the use of open-network protocols in place of proprietary protocols

A disk drive has 100 cylinders, numbered 0 to 99. Disk requests come to the disk driver for cyclinders 12, 26, 24, 4, 42, 8 and 50 in that order. The driver is currently serving a request at cyclinder 24. A seek takes 6 msec per cyclinder moved. How much seek time is needed for shortest seek time first (SSTF) algorithm? (A) 0.984 sec (B) 0.396 sec (C) 0.738 sec (D) 0.42 sec

Description : A disk drive has 100 cylinders, numbered 0 to 99. Disk requests come to the disk driver for cyclinders 12, 26, 24, 4, 42, 8 and 50 in that order. The driver is currently serving a request at cyclinder 24. A seek takes ... (SSTF) algorithm? (A) 0.984 sec (B) 0.396 sec (C) 0.738 sec (D) 0.42 sec

Last Answer : C

Does MySQL have a native counter function for its results?

Description : Does MySQL have a native counter function for its results?

Last Answer : I know that with PHP when you query the database and it returns any results it'll provide an array of results I think so you can loop through them and get the data from them, however nativly I don't ... and report what I find, if anything at all :) what langauge are you programming in by the way?

How do I check for the existence of a particular MySQL table using PHP? (Using an IF statement.)

Description : How do I check for the existence of a particular MySQL table using PHP? (Using an IF statement.)

Last Answer : answer:I don't know of a preexisting function, so here's one I wrote real quick (untested): function checkTable ($table_name, $database_name) { $my_tables [equal] mysql_list_tables($database_name); while (list($foo) ... , your_database )) { // Table exists } else { // Table does not exist }

What MySQL database admin app should I be using?

Description : What MySQL database admin app should I be using?

Last Answer : I use CocoaMySQL

Is there something wrong with my MySQL query?

Description : Is there something wrong with my MySQL query?

Last Answer : answer:SELECT CONCAT_WS( ’ ’, first_name, last_name ) AS full_name, username, country, region, CONCAT_WS( ’, ’, region, country ) AS location FROM people HAVING full_name[equal]‘John Doe’ Damn! I’ve been awake for a long time. Silly me.

What are the major differences between MySQL and SQLite?

Description : What are the major differences between MySQL and SQLite?

Last Answer : answer:Okay, from what i've picked up from wikipedia and what I know, MySQL is a seperate server process and can be run standalone on a server and requires more resources then the likes of SQLite. It ... here hehe) It entirely depends on what you're using the database for, I hope this helps :)

What do you think of this computer: http://www.dell.com/us/en/home/notebooks/inspiron-1012/pd.aspx?refid=inspiron-1012&s=dhs&cs=19&~oid=us~en~29~laptop-inspiron-10_anav1~~?

Description : What do you think of this computer: http://www.dell.com/us/en/home/notebooks/inspiron-1012/pd.aspx?refid=inspiron-1012&s=dhs&cs=19&~oid=us~en~29~laptop-inspiron-10_anav1~~?

Last Answer : There are a lot of netbooks on the market with similar specs. Read the reviews and buy by price. Try looking at the Asus EEE Netbooks on Amazon or Newegg.com, and reading the customer reviews. Dell is not the paragon that it once was, although things change and it may come back.

How do I make http://localhost/ point at my Sites folder?

Description : How do I make http://localhost/ point at my Sites folder?

Last Answer : Not on my Mac right now… but did you try File > Open… and then navigate to the local directory?

“Any asset capable of serving as a temporary abode of purchasing power is money.” This definition of money is given by (a) Milton Friedman (b) Gurley and Shaw (c) Francis Walker (d) Crowther

Description : “Any asset capable of serving as a temporary abode of purchasing power is money.” This definition of money is given by (a) Milton Friedman (b) Gurley and Shaw (c) Francis Walker (d) Crowther

Last Answer : (a) Milton Friedman

Parallel computing means doing several takes simultaneously thus improving the performance of the a. Data system b. Computer system Cc. Memory d. Vector register

Description : Parallel computing means doing several takes simultaneously thus improving the performance of the a. Data system b. Computer system Cc. Memory d. Vector register

Last Answer : b. Computer system

What exactly is cloud computing? a) A way to organize desktop computers b) Lightweight software that takes up little space on a hardware c) Computing resources that can be accessed on demand, like electricity from a utility d) The World Wide Web

Description : What exactly is cloud computing? a) A way to organize desktop computers b) Lightweight software that takes up little space on a hardware c) Computing resources that can be accessed on demand, like electricity from a utility d) The World Wide Web

Last Answer : Computing resources that can be accessed on demand, like electricity from a utility

MySQL help!

Description : MySQL help!

Last Answer : answer:You spelled “propeller” wrong, for one thing. Table SERVICE_REQUEST has a primary key, SERVICE_ID, which is a DECIMAL field. In your attempt to load the table with the error record, the secondary key value you attempted to insert for SERVICE_ID, ‘7’ is a CHAR value. That’s a show-stopper.

Empty entries in a mysql/php5 site database,... why?

Description : Empty entries in a mysql/php5 site database,... why?

Last Answer : How are you migrating the database? What are you using to export and import?

What are the best web sites to get help with Apache, PHP, and MySQL?

Description : What are the best web sites to get help with Apache, PHP, and MySQL?

Last Answer : stackoverflow is the best site programming q & a site I know of. Looks like there is a fair amount of LAMP-related questions there.

MySQL order by primary key, put one row on top.

Description : MySQL order by primary key, put one row on top.

Last Answer : answer:If you can guarantee that there is only one or zero active records select * from presets order by active asc, id asc

As a specialist PHP/MySQL programmer at my (not so fun to work at) job, what's my future?

Description : As a specialist PHP/MySQL programmer at my (not so fun to work at) job, what's my future?

Last Answer : It depends if you want to continue doing programming or not. If you have good people skills, and good business sense, you could get PMP certified, or learn VersionOne and move to the business ... business side. We also prize business analysts with SQL knowledge in order to manage data and metrics.

If I already know basic PHP/MySQL, what else should I learn to use Google App Engine?

Description : If I already know basic PHP/MySQL, what else should I learn to use Google App Engine?

Last Answer : answer:I am not an expert, I just started reading up on this myself, but here are a couple of starting points on data storage. Rather than a separately maintained SQL database, ... .com/appengine/articles/datastore/overview.html http://code.google.com/appengine/docs/python/datastore/overview.html

What is apache or perl or php or mySQL?

Description : What is apache or perl or php or mySQL?

Last Answer : Apache, Perl, PHP, MySQL Seriously, Wikipedia does wonders. Also try searching with Google.

PHP/MySQL question.... (please read on)

Description : PHP/MySQL question.... (please read on)

Last Answer : Have you looked through these?

What is a good book for learning PHP and MySQL?

Description : What is a good book for learning PHP and MySQL?

Last Answer : I’d start here: http://www.php.net/manual/en/ Get a feel for PHP, then buy books to fill in the gaps or get deeper into particular areas.

How long does it take to learn PHP & MySQL?

Description : How long does it take to learn PHP & MySQL?

Last Answer : The O’Reilly Head First book on this is great.

Add an ID column to an already existing MySQL table?

Description : Add an ID column to an already existing MySQL table?

Last Answer : I’m not an expert on MySQL [@stewartwb?], but in SQLServer that works just fine. Add the column and set the identity property and it autogenerates. What happens when you try that in MySQL? Do you get an error? or does it just not populate?

Do you know webhosting server including with these details: free, about 1-2 gigabytes, php script OK, mysql OK, no adds on site?

Description : Do you know webhosting server including with these details: free, about 1-2 gigabytes, php script OK, mysql OK, no adds on site?

Last Answer : Hosting a free Wordpress blog. Interesting. Did you try wordpress.com? Most hosts aren’t going to offer those serviced ad-free for free. I can’t think of a single one. Everyone needs a business model. And even if I found one, I certainly wouldn’t trust it for stability and security.

How can I create an ordered list of the most common substrings inside of a MySQL varchar column?

Description : How can I create an ordered list of the most common substrings inside of a MySQL varchar column?

Last Answer : SQL is definitely not my specialty but you can use regular expressions within your select statement is this something you want to pull on the fly each time though? It seems like as your data set grows it ... ve got me wondering if I can write one SQL statement for it though, let me take a look.

Can someone please explain to me exactly how PHP, mySQL, Javascript, and HTML/CSS are related?

Description : Can someone please explain to me exactly how PHP, mySQL, Javascript, and HTML/CSS are related?

Last Answer : PHP is a serverside language, while JavaScript and mySQL are clientside languages. I think the difference is that PHP/HTML is the language used by the server to encode instructions for the web browser, ... have no idea whether it's accurate or not. I just started learning this stuff this week.

Is there any difference in terms of performance to build my website's database using PostGreSQL than to built it using MySQL?

Description : Is there any difference in terms of performance to build my website's database using PostGreSQL than to built it using MySQL?

Last Answer : A few years back, the choice was between raw speed, in which case you chose MySQL, and features and reliability, in which case you chose PostgreSQL. (If you needed speed, features, and reliability, ... is what databases are built to do, but in older versions of MySQL there was simply no alternative.

MySQL Sort by every other row?

Description : MySQL Sort by every other row?

Last Answer : Couldn’t you just grab the males in a query and do the same for the females. Then loop through them in PHP. If that made any sense.

Getting certified in PHP and MySQL?

Description : Getting certified in PHP and MySQL?

Last Answer : I think Zend, the company behind PHP, has some kind of certification. Is this required for something? I’ve honestly never seen a job requiring a “certified” PHP programmer. Edit: This looks like it.

How do I do a MySQL Insert statement into 2 different tables?

Description : How do I do a MySQL Insert statement into 2 different tables?

Last Answer : sounds to me like two separate insert statements... or maybe i don't understand the question...

How can I search for a specific column name in MySQL?

Description : How can I search for a specific column name in MySQL?

Last Answer : SELECT table_name, column_name from information_schema.columns WHERE column_name LIKE 'Name';

Anyone using Spry with PHP/MySQL in Dreamweaver CS3?

Description : Anyone using Spry with PHP/MySQL in Dreamweaver CS3?

Last Answer : Why are you asking? Are you already using it, or wondering if it's a good choice of tools?

Best tools to build a collaborative project site using only open-source Apache/Mysql/PHP tools

Description : Best tools to build a collaborative project site using only open-source Apache/Mysql/PHP tools

Last Answer : answer:We've used Trac for a few projects with success. Its not perfect but it is configurable and you can extend it. Of course its geared very much towards software development and I'm not sure ... a specific set of tracking and documenting and were glad we did later on in the development cycle.

Is there a PHP library or API that would let me quickly build survey questionnaires and dump the captured data to MySQL?

Description : Is there a PHP library or API that would let me quickly build survey questionnaires and dump the captured data to MySQL?

Last Answer : If you are familiar with LAMP and PHP, why not build a little CRUD application?

Good advanced MySQL tutorial?

Description : Good advanced MySQL tutorial?

Last Answer : I don’t know of a specific one but I know http://www.pixel2life.com/ has lots of web-related tutorials, I’ve always found it to be a great resource. Joining irritates me, covered it in SQL w/ Oracle, hated every minute of it! If I find anything in the mean time I’ll post it here.

Approximately how many connections per second could a MySQL server with 64mb of memory handle?

Description : Approximately how many connections per second could a MySQL server with 64mb of memory handle?

Last Answer : Nevermind. The answer is between 1200/sec and 2000/sec, but obviously dependent on the load of the request.

MySQL WHERE doesn't work.

Description : MySQL WHERE doesn't work.

Last Answer : answer:Try changing the WHERE clause to: WHERE LOWER(`Title`) LIKE '%trumpet%' (using LOWER makes the search case-insensitive) In SQL, % is a wildcard that matches any number of characters (even zero ... a space in a table name. I'd recommend a migration from `Methodes Walter` to `Methodes_Walter`.

What MySQL engine would you recommend?

Description : What MySQL engine would you recommend?

Last Answer : answer:I'm a big fan of the whole foreign key' concept, so I really only use InnoDB (since MyISAM doesn't support it). If I remember correctly, general statements run faster on InnoDB than ... a determining factor. Though if you plan on implementing a full-text search, go with MyISAM for sure.

Error message when using PHP with MySQL.

Description : Error message when using PHP with MySQL.

Last Answer : Wow! Good luck with that!

Are there any resources that you can recommend for me to learn LAMP (Linux Apache MySQL Perl/Python/PHP?

Description : Are there any resources that you can recommend for me to learn LAMP (Linux Apache MySQL Perl/Python/PHP?

Last Answer : I’m not educated in this type of stuff, but I did a little research and got these. http://lamphowto.com http://onlamp.com

What the hell is wrong when i create connection btw navicat and mysql?

Description : What the hell is wrong when i create connection btw navicat and mysql?

Last Answer : answer:This probably isn’t a bug or issue with the MySQL server. The possibilities are: 1) Login password for root is wrong 2) The account doesn’t have a password Have you tried connecting without a password?

How to import a html table into mysql?

Description : How to import a html table into mysql?

Last Answer : Do you have a link to the table? Unless somebody is aware of a script that I haven’t come across, the script would be specific to the table and shouldn’t be too hard to write.

What is your favorite PHP/MySQL ecommerce application and why?

Description : What is your favorite PHP/MySQL ecommerce application and why?

Last Answer : answer:

Ms. Archana, a class XI student has just started learning MySQL. Help her in understanding the basic difference between -Technology

Description : Ms. Archana, a class XI student has just started learning MySQL. Help her in understanding the basic difference between -Technology

Last Answer : ALTERUPDATEIt s a DDL command.It s a DML command.It can be used for the following purpose:To add a new column.To remove an existing column.To modify a column.To add/remove a constraint.It s ... Delhi ;suitable command:(i)Show Databases(ii) Use City(iii) Drop Database Clients(iv) Drop table Club

is_connected() is the MYSQL function to : -Technology

Description : is_connected() is the MYSQL function to : -Technology

Last Answer : (e)verify whether the python application is connected to mysql database.

Shewani has recently started working in MySQL. Help her in understanding the difference between the following : -Technology

Description : Shewani has recently started working in MySQL. Help her in understanding the difference between the following : -Technology

Last Answer : (i) Where clause is used to show data set for a table based on a condition and having clause is used to put condition on the result set that comes after using Group by clause.(ii) COUNT ... unique as single column or combined multiple columns to the table. They are all candidates for Primary Key.

In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Description : In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Last Answer : import mysql.connectormydb = mysql.connector.connect{host='localhost',user='root',passwd='cbse',database='school'}mycursor = mydb.cursor()mycursor.execute('INSERT INTO student values(3,'Michelle', 'Agartala');')mydb.commit()

Write the code in python to read the contents of “number.csv” file consisting of data from a mysql table and print the data of the table -Technology

Description : Write the code in python to read the contents of “number.csv” file consisting of data from a mysql table and print the data of the table -Technology

Last Answer : f = open('numbers.csv', 'r') with f:reader = csv.reader(f)for row in reader:for e in row:print(e)

What is MySQL used for? Abhay wants to start learning MySQL. From where can he obtain the MySQL software? -Technology

Description : What is MySQL used for? Abhay wants to start learning MySQL. From where can he obtain the MySQL software? -Technology

Last Answer : MySQL is a Relational Database Management System (RDBMS), used for adding, accessing and processing data in a database. Abhay can download the MySQL software setup from Internet.