| Author |
Message |
|
|
capebretoner
Joined: 18 May 2006
Posts: 167
|
 Posted: Mon Jun 26, 2006 5:40 pm Post subject: MySQL tables |
 |
|
I have a table for a counter that I just finished. So far it has over 1000 entries, so I am thinking that it will not take very long for this thing to get huge. Now there is not a lot of information in any one of these rows so the database is not going to be MB big, just a lot of rows.
Is there a limit that I should be thinking about, or is one of those things that I don't really need to worry about
BTW if you are interested in the counter you can grab the code here, I will be making it prettier in the near future.
_________________
Webmaster Blog | Free forums | Free Hit Counter |
|
| Back to top |
|
 |
|
|
scolls
Joined: 31 May 2006
Posts: 242
|
| Posted: Fri Jun 30, 2006 8:50 pm Post subject: |
|
|
I wouldn't worry about it at all - just be sure to index the columns you'll be querying on.
Otherwise you'd be searching through each row, and that's expensive! How many rows do you expect? A million?
_________________
WebWobot Search Engine & Forums | WebWobot PageTrade Multi-Exchange |
|
| Back to top |
|
|
seo
Joined: 16 Mar 2006
Posts: 1999
|
| Posted: Thu Jul 06, 2006 9:32 pm Post subject: |
|
|
| scolls wrote: |
Otherwise you'd be searching through each row, and that's expensive! How many rows do you expect? A million? |
Yeah ... tell us the current status.
_________________
Travel News Online College Degree |
|
| Back to top |
|
|
scolls
Joined: 31 May 2006
Posts: 242
|
|
| Back to top |
|
|
www.CompuForums.org
Joined: 19 May 2006
Posts: 81
|
| Posted: Mon Jul 10, 2006 6:09 pm Post subject: |
|
|
Of course, you can easily use cPanel's database optimizer if you have cPanel. Of course, if you can put an optimizer into your software, even better.
_________________
 |
|
| Back to top |
|
|
capebretoner
Joined: 18 May 2006
Posts: 167
|
| Posted: Tue Jul 11, 2006 1:35 pm Post subject: |
|
|
Well I have had the counter available for a bit and already I am at 10000 different pages that are being counted. Of course I forgot to check for session id variables for known programs and remove them before checking so that means that the number of pages is inflated slightly.
I will be optimizing the table daily and will be optimizing the script to minimize the unnecessary "new" pages.
_________________
Webmaster Blog | Free forums | Free Hit Counter |
|
| Back to top |
|
|
Camron
Joined: 14 Jul 2006
Posts: 110
|
| Posted: Fri Jul 14, 2006 11:20 pm Post subject: |
|
|
| wow thanks for the links guys |
|
| Back to top |
|
|
|
|
|
|
|
