Database storage or flat file?

[Matt]

Upgraded the server to another gig of ram + 100mpbs and they moved the vps to another server. Sites running much faster and smoother

[traumatic]

[DoubleDutch]

and expensive?

[Matt]

As long as people click on the ads it'll be profitable

[DoubleDutch]

Whats the site url?

[Matt]

If you're really interested I can PM you lol

[DoubleDutch]

Ok, please PM me - I'm really curious now.

btw: you should link from here - won't it 'up' your google rank?

[Pantcho!!]

PM me the site, I hope we all get free membership

[Thalius]

linklink ! hehehe

On the long run i think you dont get around a profile system where you store related votes inside the profile DB.

Create a Vote Table with all votes by user ID ( index field ) or IP (well IP restrictions apply bad idea).

Then create a link table which links votes against user IDs and then do a left joint query across both tables. This is probably the fastest way and uses a binary indexing and search on the db tables inside mysql.


Or Simpler:
Use a Table for IPs stored as Integers ( Longs ) then use this as (Indexed!) lookup table with a COUNT query on the IP Table and IF the result is greater than 1 the user has voted and then you can do the real query on the Votes table to get the IDs and compare them. That way you just do the hard query on need.

To create a Integer Decimal based IP ID you can use the following:

Code: Select all

<?php
$a = 192 ;
$b = 168;
$c = 1;
$d = 1;

$ip = $a*pow(256,3) + $b*pow(256,2) + $c*256 +$d ;
echo $ip;
?>

Cheers,
Thalius

[Matt]

links sent, just remember the site makes money and enjoy

linklink ! hehehe

On the long run i think you dont get around a profile system where you store related votes inside the profile DB.

Create a Vote Table with all votes by user ID ( index field ) or IP (well IP restrictions apply bad idea).

Then create a link table which links votes against user IDs and then do a left joint query across both tables. This is probably the fastest way and uses a binary indexing and search on the db tables inside mysql.


Or Simpler:
Use a Table for IPs stored as Integers ( Longs ) then use this as (Indexed!) lookup table with a COUNT query on the IP Table and IF the result is greater than 1 the user has voted and then you can do the real query on the Votes table to get the IDs and compare them. That way you just do the hard query on need.

To create a Integer Decimal based IP ID you can use the following:

Code: Select all

<?php
$a = 192 ;
$b = 168;
$c = 1;
$d = 1;

$ip = $a*pow(256,3) + $b*pow(256,2) + $c*256 +$d ;
echo $ip;
?>

Cheers,
Thalius

thanks for the tips

[DoubleDutch]

Just seen the link - not normally something I'd visit, but I can understand how it could make you some $.