Register
FAQ
Calendar
Search
Today's Posts
Rules
Guidelines
SMS enable your application
via Clickatell’s fast, simple and reliable API's, built to integrate with any system.
Click here
to learn more.
Flash Website Builder
- Trendy Site Builder is a Flash Site Building tool that helps users build stunning websites.
Check Out Custom
Custom Logo Design
by LogoBee. Website Design and Free Logo Templates available.
CodingForums.com
>
:: Server side development
>
MySQL
Overall site speed and performance - How will it be affected by a table..
User Name
Remember Me?
Password
Before you post, read our:
Rules
&
Posting Guidelines
Thread Tools
Rate Thread
Enjoy an ad free experience by logging in. Not a member yet?
Register
.
11-09-2012, 03:27 AM
PM User
|
#
1
user.name
New Coder
Join Date: Aug 2007
Location: Philippines
Posts: 26
Thanks: 9
Thanked 0 Times in 0 Posts
Overall site speed and performance - How will it be affected by a table..
I currently have a table in my mySQL database that continually receives data (accumulates up to 16k~ rows for less than 20hours)
Data is saved through ajax, on user mouse action.
The table is flat with 4 fields:
int(10
varchar(255)
text
date (timestamp)
I use php. How will this table affect overall site speed and performance? Thanks!
Last edited by user.name; 11-09-2012 at
03:38 AM
..
user.name
View Public Profile
Find More Posts by user.name
11-09-2012, 05:18 AM
PM User
|
#
2
Old Pedant
Supreme Master coder!
Join Date: Feb 2009
Posts: 23,236
Thanks: 59
Thanked 3,997 Times in 3,966 Posts
Too broad a question.
What indexes are there on the table? What kinds of queries will you be using? What fields will be used in your WHERE clauses and/or JOINs?
Will you ever "prune" this table? (Remove old records, that is.)
TEXT fields are, in general, the killer in DB performance. How large, on average will your TEXT contents be?
Or maybe a better question: How much disk space are you adding to the DB per day?
__________________
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
Old Pedant
View Public Profile
Find More Posts by Old Pedant
Bookmarks
del.icio.us
StumbleUpon
Google
Digg
Tags
php
,
site performance
,
site speed
Jump To Top of Thread
«
Previous Thread
|
Next Thread
»
Thread Tools
Show Printable Version
Email this Page
Rate This Thread
Rate This Thread
:
5 : Excellent
4 : Good
3 : Average
2 : Bad
1 : Terrible
Posting Rules
You
may not
post new threads
You
may not
post replies
You
may not
post attachments
You
may not
edit your posts
BB code
is
On
Smilies
are
On
[IMG]
code is
On
HTML code is
Off
Forum Rules
Forum Jump
User Control Panel
Private Messages
Subscriptions
Who's Online
Search Forums
Forums Home
:: Client side development
JavaScript programming
DOM and JSON scripting
Ajax and Design
JavaScript frameworks
Post a JavaScript
HTML & CSS
XML
Flash & ActionScript
Adobe Flex
Graphics and Multimedia discussions
General web building
Site reviews
Building for mobile devices
:: Server side development
Apache configuration
Perl/ CGI
PHP
Post a PHP snippet
MySQL
Other Databases
Ruby & Ruby On Rails
ASP
ASP.NET
Java and JSP
Other server side languages/ issues
ColdFusion
Python
:: Computing & Sciences
Computer Programming
Computer/PC discussions
Geek News and Humour
Web Projects and Services Marketplace
Web Projects
Small projects (quick fixes and changes)
Medium projects (new script, new features, etc)
Large Projects (new web application, complex features etc)
Unknown sized projects (request quote)
Vacant job positions
Looking for work/ for hire
Project collaboration/ partnership
Paid work offers and requests (Now CLOSED)
Career, job, and business ideas or advice
Domains, Sites, and Designs for sale
Domains for sale
Websites for sale
Design templates and graphics for sale
:: Other forums
Forum feedback and announcements
All times are GMT +1. The time now is
04:02 AM
.
Advertisement
Log in to turn off these ads.
Web Hosting UK
|
Dedicated Server Hosting
|
Shareware Junction
|
Software Geek
|
Flash file uploader
|
Cloud Server
|
Web Hosting Australia
Home
-
Contact Us
-
Archives
-
Link to CF
-
Resources
-
Top
Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.