Which is faster

[crashwave]

I am making new files for a contribution and I need to find out a simple yet evasive answer.

Which is faster

PHP file seach or Mysql

 

For example

The Configuration table lets use STORE_NAME

would it be faster If this was in a definiton file say english.php

Define ('STORE_NAME', 'store name);

 

also which one uses less/more server resources.

That is one simple example. Consider several others at similar instances.

Like if we had the entire configuration table in one configuration.php file.

 

Thanks

 

Heidi

[AlanR]

For example

The Configuration table lets use STORE_NAME

would it be faster If this was in a definiton file say english.php

Define ('STORE_NAME', 'store name);

 

also which one uses less/more server resources.

That is one simple example. Consider several others at similar instances.

Like if we had the entire configuration table in one configuration.php file.

 

Thanks

 

Heidi

<{POST_SNAPBACK}>

 

It's been done before:

 

http://www.oscommerce.com/community/contributions,1862

[crashwave]

The configuration table was an example, that is not what I am working on.

I need to know wether it is better to have definitions in the tables or in the files. There are a lot of definitons I need to add, and I wanted to know wether to add them in a file or table.

But I guess the answer is on that contrib page.

So it is faster to use a page and not the database???

[Jack_mcs]

Yes, php code is much faster than getting the data from the database.

 

Jack

[wizardsandwars]

Yes, php code is much faster than getting the data from the database.

 

Jack

<{POST_SNAPBACK}>

 

At least until you get into the hundreds of thousands of rows. Then the database starts to catchup, and eventually surpass the operating system level.

[Jack_mcs]

Possibly, although on average I think the code would be faster. Afterall, to access the database a connection has to be made and connections can take a considerable amount of time depending on things like server load and the weather.

 

Jack

[wizardsandwars]

If you are using the native client drivers for the dbms, the connection time should also be very small. And it would depend on the number of joins in the query, and whether or not the table(s) are indexed properly, whethe or not the dbms supports bitwise indexing, wheter or not the tempdb is seperated out on a different device than the the primary data device.

 

Other considerations would be how high the cpu utilization is, how much paging space is in use and others.

 

I'd done a small amount of testing in this area, and for high volume talbes, it was very close.

[Jack_mcs]

I haven't done any testing so your results are good enough for me.

 

Jack