Adrian Tanase

33 reputation

bio	website	xplore.cubeworx.net
	location	Bucharest, Romania
	age	33
visits	member for	11 months
	seen	14 hours ago
stats	profile views	6

Just me.

Web Programmer, sketch artist as a hobby and making music (producer).

	33 reputation	bio	website	xplore.cubeworx.net	visits	member for	11 months
6 badges		location	Bucharest, Romania		seen	14 hours ago

summary answers questions tags badges favorites bounties reputation activity

27 Actions

suggestions reviews revisions comments badges posts accepts all

Feb 28	comment	managing a growing database in the long run (10 years from now) i see....this is my very ideea too, start prospecting on solutions, not just worrying about hdd space, db size etc. but I didn't know how to put it right in my question. I need to know before i launch the website if, at some point in the future, I can migrate to other optimised solutions, because site will build up and everything needs to be flexible in adapting to optimized solutions. thanks :)
Feb 28	comment	managing a growing database in the long run (10 years from now) thanks for the excellent advices. For the beginning it's definitely safe to keep images (folder tree) and DB (mySql InnoDB tables) on one server, it has 60GB ssd Raid 1 and 3 GB ram with pretty powerful processor. For low income hosting it's best what I got. But in the long run, I think I will need. Q : Why raid 10 for mysql volume ? THe hosting has raid 1, and since it's SSD good qual Intel i guess, it's super fast. In the long run i'll probably switch to raid 1 with 7200 rpm standard hdd, since it encases more space and it's not expensive. or maybe ssd on my own server..
Feb 28	comment	managing a growing database in the long run (10 years from now) i considered using InnoDB for row-locking (not table). The site uses a lot of AJAX small updates (like the Like button on Facebook) and also not very frequent regular INSERTS, and a lot of READS. Pictures are being kept in the tree folder, and database is only text and numbers used to display stuff on the frontpage. I also have 2 separate admins, which will bring a lot of traffic and also the browsing through the stuff they define, on the frontpage which will bring a lot of reads on the httpd and mysql side.
Feb 27	asked	managing a growing database in the long run (10 years from now)
Nov 2	awarded	Tumbleweed
Oct 26	asked	Should I use compression in my InnoDB tables for this project?
Oct 14	comment	Trouble with PDO query + LEFT JOIN here's the link stackoverflow.com/questions/12788352/…
Oct 14	comment	Trouble with PDO query + LEFT JOIN i managed to get an answer on stackoverflow, where the community seems more active and they do answer a lot on mysql stuff, i did an INNER join table ON condition (where it displays only the ON condition id's)...and worked :)
Oct 8	comment	Trouble with PDO query + LEFT JOIN to make myself clearer, i need to select those 4 fields (contact_id, name, city, ext) from myl_contacts (1 field) and mya_users(3 fields) but I don't have to list any particular fields that are listed in myl_blocked_contacts
Oct 8	awarded	Commentator
Oct 8	comment	Trouble with PDO query + LEFT JOIN should i move my question to stackoverflow in the quest of getting any answers ? or to other website ? thanks
Oct 8	comment	Trouble with PDO query + LEFT JOIN i don't know where I'm wrong...why does not the query work...where am I doing wrong...any help is appreciated...i managed to replace old mysql_num_rows and all old code to PDO::style and now i want to upgrade it as well, it took around 2 months to replace all code
Oct 8	asked	Trouble with PDO query + LEFT JOIN
Aug 10	accepted	Cannot retrieve values from LEFT JOIN (2 tables)
Jun 22	awarded	Supporter
Jun 22	comment	*PDO count() does not work with LIMIT and OFFSET** thanks, now i understand it better
Jun 21	comment	*PDO count() does not work with LIMIT and OFFSET** i wonder tho, what is the A at the end of the statement meaning
Jun 21	awarded	Scholar
Jun 21	accepted	*PDO count() does not work with LIMIT and OFFSET**
Jun 21	comment	*PDO count() does not work with LIMIT and OFFSET** $query_list_records = "SELECT COUNT() from (SELECT from myl_news_comments WHERE news_id=? LIMIT ? OFFSET ?) A"; this will select the count well and displaying total with $total_records = $result_list_records->fetchColumn();