Identifying elements from data feeds generated by affiliate sites
I am working with data feeds from affiliate sites. The basic idea is to provide an interface where the user can paste a link to an XML datafeed (these are huge btw, around 60 mb) that would then be streamed, parsed into small chunks, and mined for the required data which would then be stored in the database.
Using replacement to get possible outcomes to then search through HUGE amount of data
I have a database table holding 40 million records (table A).
What’s the difference between the insert methods and why one is faster
I have insert 14.485 lines on MySQL like this:
Making the switch from MySQL to PostgreSQL?
I’ve spent the last year becoming really comfortable with MySQL, but due to its increasing trendiness and my desire to homogenize my web-apps with Heroku, I’d like to start using PostgreSQL for my web apps instead. There are a resources out there for learning PostgreSQL, but I don’t really want to have database concepts explained to me from scratch again, and I don’t want to have to re-learn all the stuff that’s pretty much the same.
Help with DB Structure, vOD site
I have a video on demand style site that hosts series of videos under different modules. However with the way I have designed the database it is proving to be very slow. I have asked this question before and someone suggested indexing, but i cannot seem to get my head around it. But I would like someone to help with the structure of the database here to see if it can be improved. The core table is Videos:
Is it safe to use LAST_INSERT_ID() in a system like Point of Sale
Is it safe to use LAST_INSERT_ID() in a system using MySQL like Point Of Sale when there are multiple users using the system at the same time?
My father wants to learn PHP-MySQL to port his application. What I should do to help? [closed]
Closed 9 years ago.
Breaking up a large PHP object used to abstract the database. Best practices?
Two years ago it was thought a single object with functions such as $database->get_user_from_id($ID) would be a good idea. The functions return objects (not arrays), and the front-end code never worries about the database.
Are there any conceptual drawbacks to building a web app with C++ and MySQL?
I’ve inherited a pretty interesting project where there is a good opportunity to take an existing piece of software and turn it into a SaaS web app. As the project is inherited, the code base/ framework is already defined as C++ and MySQL. The app itself is compiled and run as an EXE on Windows Server. The UI is web based and the app works as a kind of server. From what I do know of modern web apps, this is perhaps an unusual choice. These days, most people seem to opt for a PHP framework or Ruby on Rails. Certainly that is the impression I get from reading blogs on the subject. So, I’m very interested to know if a C++ EXE backed by MySQL is a solid foundation for a web app, or whether we should be looking to build in another way?
What to learn after standard C++? [closed]
Closed 12 years ago.