Freelancers Forum Messages on Thursday September 21st 2006
RE: FN-FORUM: dB growth
date posted 21st September 2006 22:49
> Doesn't everyone have database migration scripts for this sort of
> stuff? How else do you test on a separate server and know that
> it'll work on the live one(s)?
Lol...you'll be surprised...
Re: FN-FORUM: dB growth
date posted 21st September 2006 19:47
Dave Boulden wrote:
> Let's say you go down the 1 db per customer route and you do well and have
> 50 customers (hence 50 databases). You come up with a new feature you want
> to give to each custome...
Re: FN-FORUM: FTP
date posted 21st September 2006 16:40
Sounds like you have most likely uploaded the files into the wrong
directory I suggest you check the details carefully.
Clare Plumtree wrote:
>
> I don't know very much about ftp, as some as you may...
Re: FN-FORUM: FTP
date posted 21st September 2006 16:14
A-ha, yes you were right! I was just in the directory rather than
htdocs! DOH, I've been puzzling over that since friday! (but then I
have been away sat-weds!)
Thanks for the help!
On 21 Sep 2006 15:...
Re: FN-FORUM: FTP
date posted 21st September 2006 16:11
[EMAIL REMOVED] wrote:
> Are you sure you are FTP'ing to the right place? If you overwrite the files
> on there then the changes should appear. Try renaming one of the files on
> the server to see if...
Re: FN-FORUM: dB growth
date posted 21st September 2006 16:07
On Thursday 21 Sep 2006 4:12 pm, Dave Fennell wrote:
> Although that is a slight simplification I too prefer the idea of
> separate databases per customer. Database systems are not designed to
> res...
RE: FN-FORUM: FTP
date posted 21st September 2006 16:04
Are you sure you are FTP'ing to the right place=3F If you overwrite the fi=
les
on there then the changes should appear=2E Try renaming one of the files o=
n
the server to see if it is the correct fil...
FN-FORUM: FTP
date posted 21st September 2006 15:54
I don't know very much about ftp, as some as you may recall me saying
from previous posts. I had to upload my brothers website through ftp
and did so with a 30 day free trial of WS_FTP, which was what...
Re: FN-FORUM: dB growth
date posted 21st September 2006 15:52
[EMAIL REMOVED] wrote:
> -----Original Message-----
> From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Mark
> Bell
> Sent: 21 September 2006 12:10
> To: Anslow, John
> Subject: RE: FN-FORUM: dB gro...
FN-FORUM: Animated Gif not Animated!!
date posted 21st September 2006 15:37
Good Afternoon all!
Right, I have made a "please wait while flights load page" which has
an animated gif on it. This page is called, and then directly calls
another page, and the mySQL query is execu...
Re: FN-FORUM: dB growth
date posted 21st September 2006 14:55
On Thursday 21 Sep 2006 1:18 pm, [EMAIL REMOVED] John wrote:
> 1. set session("company_id")=3Dsomeone else's company_id
Session variables are keyed to the session ID and stored on the=20
server, not...
Re: FN-FORUM: SQL sub query
date posted 21st September 2006 14:21
On 19 Sep 2006 18:32:16 -0000, Dai Williams [EMAIL REMOVED] wrote:
> Sounds like you just need
>
> LEFT OUTER JOIN tblResults ON tblClients.ClientID = tblResults.ClientID AND
> tblResults.GroupID = {g...
RE: FN-FORUM: dB growth
date posted 21st September 2006 13:09
That pretty much nails it really Dave.
Loving the sub domain idea.
Anslow - I'm thinking the company_id SESSION var would be a nice long hashed
string, so a/ not easy to change and b/ difficult to e...
RE: FN-FORUM: dB growth
date posted 21st September 2006 12:58
1. set session("company_id")=3Dsomeone else's company_id=20
2. go to query page
3. read some one else's data
QED
-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Mark...
RE: FN-FORUM: dB growth
date posted 21st September 2006 12:56
I've not been following this thread too closely, but I'm rather amazed that
anyone would recommend separate databases over a single database for all
customers. You should view the database as the data...
RE: FN-FORUM: dB growth
date posted 21st September 2006 11:50
Sure, backup is no drama - it's all automated anyway, no diff to me whether
it's bzip'ing 2 or 20. At least until they are huge.
I wouldn't have thought cross-client security would be impacted as in...
RE: FN-FORUM: dB growth
date posted 21st September 2006 11:26
Data security ?
Having separate databases would ensure that no customer could gain
access to another customer's data, I'd have thought backing up two
databases is not much harder than backing up one...
Re: FN-FORUM: Which Where does a query use if there is more than one?
date posted 21st September 2006 11:05
On Thursday 21 Sep 2006 10:27 am, Jonathan Dorling (Dorling Consultancy)=20
wrote:
> But I want it to come back with only on of the OR's not all 3
What's the *real* problem you are trying to solve?...
Re: FN-FORUM: dB growth
date posted 21st September 2006 11:03
[DB per company vs. single DB]
I'm not convinced by Al3x's arguments (yet - give it another go if you wa=
nt!)=20
and the drawbacks in maintaining tables in separate DBs, having to back u=
p=20
separ...
RE: RE: FN-FORUM: Which Where does a query use if there is more than one?
date posted 21st September 2006 10:38
yep, splitting it into 3 is your best bet if you only want to do one query at a time
>
>Ok I see what you are saying.
>
>How could I write a query to do this
>
>A Car with sunroof AND electric OR a...
Re: FN-FORUM: Which Where does a query use if there is more than one?
date posted 21st September 2006 10:31
> How could I write a query to do this
>
> A Car with sunroof AND electric OR a sunroof AND metallic paint OR a
> sunroof
> AND Leather seats AND metallic paint.
You'll need some parentheses to spe...
RE: FN-FORUM: Which Where does a query use if there is more than one?
date posted 21st September 2006 10:29
If you don't mind which one is returned (ie there is no implicit order =
of
preference) as long as one and only one is returned which satisfies the
conditions, you could wrap the whole query in a summ...
RE: FN-FORUM: Which Where does a query use if there is more than one?
date posted 21st September 2006 10:08
Ok I see what you are saying.
How could I write a query to do this
A Car with sunroof AND electric OR a sunroof AND metallic paint OR a sunroof
AND Leather seats AND metallic paint.
But I want it...
RE: FN-FORUM: Which Where does a query use if there is more than one?
date posted 21st September 2006 09:55
you've only got one WHERE, but lots of AND's and OR's. The SQL will test records against your conditions (in your code, the OR sort of signifies a new condition) and return the results.
for exampl...
RE: FN-FORUM: Which Where does a query use if there is more than one?
date posted 21st September 2006 09:54
Jonathan
It has to use all of them - some are being used to join tables on common
keys, and some are being used (eg fromdate) to restrict the result set =
on
other variables.
An SQL query will retur...
FN-FORUM: Which Where does a query use if there is more than one?
date posted 21st September 2006 09:44
I have a query below with a lot of Where parts But how does it know which
one to use?
Thanks
Jonathan
SELECT dbo.tbl_names.[Full Name], tbl_links.contactedbyother,
tbl_links.contactedbyIC...
RE: FN-FORUM: dB growth
date posted 21st September 2006 08:25
Thank al3x,
That was exactly my concern ... the extra redundancy in separate dB's is
attractive, I guess I could/would have to write a little script to
add/update tables in each of them if a global u...
Re: FN-FORUM: dB growth
date posted 21st September 2006 05:00
If you are interested in opinion from the sysadmin point of view -
Each business should have the separate database - you will eliminate the
"single point of failure" earlier at design level.
You can h...
|
|