Jump to content

how can i go about making my server perform queries fastest?


Recommended Posts

i'm creating an intricate site. the options for database are: mysql, sqllite, or xml

 

it will communicate with php. i need to know, 1) which will be the fastest and lightest on bandwidth/server load overall (when the site gets massive), 2) which is most similar to mysql queries (sqllite or xml), 3) can sqllite and xml perform: select, update, delete, insert similar to the queries by mysql (i know there's something for xml called "xml_query2xml" in pear, but does this allow you to do insert, delete, and update like you would in mysql?)

 

also, if you can provide any xml frameworks that do the following for databases, that'd help toO!!

 

thanks, alex

Link to comment
Share on other sites

SQLite is very similar to MySQL as they're both SQL.

Although there are some noticable differences, like SQLite not enforcing datatypes and lacking support for some things.. especially if you use the php sqlite functions as that's SQLite 2 as opposed to the SQLite3 that's available via the PDO driver. Something lacking is for example foreign keys not being enforced, meaning you will have to write triggers if you want a cascading delete.

 

SQLite does perform faster than mysql for the most common queries (select). Not sure how you intend to tie in XML to this. XML is a markup language, not really an alternative to SQL. Perhaps you got confused by the term "xpath query".

If you use PDO then switching from mysql to sqlite or vice versa should be quite trivial.

 

Edit

Do note however that before things get to the point of exceptional loads you'll need to stress them A LOT. And rewriting queries in a more efficient manner usually means a far greater speed up than the actual database in use.

 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.