Jump to content


Photo

File access speed versus database access speed


  • Please log in to reply
3 replies to this topic

#1 Zipp425

Zipp425
  • Members
  • PipPip
  • Member
  • 18 posts

Posted 16 October 2006 - 05:30 AM

Title says it all...

#2 tomfmason

tomfmason
  • Staff Alumni
  • Advanced Member
  • 1,696 posts
  • Locationstealing your wifi

Posted 16 October 2006 - 05:45 AM

I guess that would depend on how many queries you are going to be preforming. The only thing that I can suggest is to use micro time to test the speed of both and then make a decision based on the time.

Here is an example.

$start = microtime(true);
//some code here

$end = microtime(true);
$time = $start - $end;

hope that helps,
Tom
Tom

Traveling East in search of instruction, and West to propagate the knowledge I have had gained.

current projects: pokersource

My Blog | My Pastebin | PHP Validation class | Backtrack linux


#3 Zipp425

Zipp425
  • Members
  • PipPip
  • Member
  • 18 posts

Posted 16 October 2006 - 06:07 AM

Alright, Thanks tom, that actually helps alot. I didnt know there was a micro time function... haha.

#4 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 16 October 2006 - 10:06 AM

Files are always faster then a database but the programming for files is a lot more work so most users use a database.

Post your thorts on the microtime help you got.
Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users