Correct. And when you compare creating connections to mysql with opening a file with C++, it's no wonder why the latter is so much faster.

Mysql itself can also cache queries - and usually does so by default with often recurring queries - but this doesn't take away the time it takes to build a connection.
And not by far does every server support persistent database connections, so it would be foolish to write a (free) trade script in php that supports that.

That's sort of what I was thinking.


Maybe in a virtual environment... but on your own dedicated machine, serving hundreds of thousands to millions of clicks coming in from hundreds of different people going out to hundreds/thousands of different links, all the while parsing and analyzing the data....

Flatfile faster than MySQL? Err I don't think so.

CAN php take advanatage of those features? Cached queries & persistent conections like you can do with mod_perl?

TTT Vs UCJ?

UCJ all the way :thumbsup

Btw, like everyone else said, dont rely on a script to grow your site. Its up to you to grow your site.

Well I can't see any site needing 89million hits worth, so really what your test shows is either will work just fine and if tuned properly you could speed up the mysql version.

:):glugglug Amen
I like TM3 better. Sends out better uniques imho.

true, both can be used, but mysql only to a certain level.
It's not for no reason I keep hearing from more people every day that they switched to AT because php/mysql scripts started to slow down @ 50k.

Also, I used a C++ program to test mysql. And only used one query (select *). Now go through the source of a php script, and count the amount of queries that are used to handle incoming and outgoing scripts....

And last, this program was a stress test, meaning it used all resources that were free; especially with the mysql test it boosted the cpu load to very high levels.
That's okay for a test, but in real life you don't want a server load of 50+

Don't know enough about php to answer this one since I am a perl programmer. Sorry :(

Same here - I have it installed on one of my sites.

Although if I had to choose a free script it would be arrowtrader hands down :thumbsup

49 fool! Whut!

Media

50

I installed TTT.. have not sent shit thru it yet.. but I look foreward to giving it a test run.. Bringing back one of my old sites to see what I can get it to do.. Prolly a waste of time, but I got a plan so its all good..

Media

NEWBS!!!!!!!!

- Ogre "Revenge of the Nerds 1988"

Try this one:

http://www.moduletown.com we have just launced the script in sponsored mode so you can try it out before buying.

Module Town Tradescript v. 1.82
Free version now available! It has ALL the functionality of the paid version and it only takes 2% of traffic.
You might wanna lower that 2% a bit to become more competetive.

It's programmed in PHP and uses MySQL and backend database. Now you probaly heard that c might be faster but this is far from the truth
And stop bullshitting other webmasters :winkwink:

Well I think 2% is fair when you think of all the functionality. If it's too much just don't use it:)

Regarding the speed then it's up for discussion what is faster c or php encoded.

The laungauge is not that important but the access to db. is much more important and here MySQL really does the job.

btw, c++ is soooo much slower than c. Why have you not just made arrowtrader in pure c instead?

I wrote it in C++ because it simply isn't slower than C.
It's a very common mistake to think that.
C is a subset of C++, so even when I say I've
written in C++, I could have used strictly C code.
But I didn't.

Using C++, I was able to use things like STL, which
give more flexible and faster code than C programs.

anyway, I don't want to get into a whole discussion about C vs C++, but whoever says C is faster simply doesn't know how to write optimized code in C++.

So to sum it up;
- at least equal speed - code is easier to read (imo) - stronger dynamic memory management libraries - better type checking - plus, I am much better in C++ than in C :thumbsup

ucj in terms of serveload by far
and ttt is free so it sucks some traffic from you

Stop bitching eachother, go to http://www.arrowscripts.com and download the free version. You will be in love tomorrow. I don't fucking care a trading script uses MySQL or flat files, as long as it doesn't slow down at 50k. And yes you are correct a good webmaster can build a TGP with any trading script. But ArrowTrader will help you a lot with it's unbeatable return module.

Some people probably hate me now, :321GFY . I don't have ArrowAcripts stocks... I just want to share my experience with it. Face the truth.

And by the way, even the free version has probably better support than many paid scripts.

Here is a free trade programmed in C that doesn't steal traffic directly:

http://www.awgtrade.com

arrowtrader all the way
http://www.worthlessporn.com/arrow-growth.gif

Nice growth you got there SN :)
In the end there's nothing like real-life facts.
What script were you using before AT i I may ask??