Freelancers Forum Messages on Monday July 23rd 2007
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 23:20
Graham Stark wrote:
> Most likely it isn't. Essentially, sql index puts the postcodes in order
> (of some kind) and does a binary search on it: look in the middle of the
> index; if the value is les...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 23:17
Dom Latter wrote:
> You're just shifting part of the search from a highly optimised environment
> (the database engine) to a very slow and clunky interpreted environment.
That action can also be han...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 23:15
Graham Stark wrote:
> There are various good guides to tuning large mysql databases if you
> google.
>
> Graham
Horizontal partitioning is a tried and tested database tuning pattern.
--
Cheers,
G...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 23:12
Dom Latter wrote:
> Why is many tables better than one?
Let's say you have 1,000 records in one table and then you horizontally
partition it into two tables each of 500 rows. Now it takes half the...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 23:08
Tom Miller wrote:
>
> Jay,
>
> I have a postcode database running in MySQL. It is 8GB in total and the
> postcodes table has 27,500,000 records. Works absolutely fine on medium
> spec machine.
Ye...
FN-FORUM: After a Designer
date posted 23rd July 2007 22:57
Hi Guys,
I'm after a freelance designer who will can produce templates to my clients
requirements.
All programming is done by ourselves, so all we're after is the design.
If you live around the Man...
Re: FN-FORUM: Spams methods changing
date posted 23rd July 2007 22:48
That has happened to me last week as well.
I get the my friend cards and my domain was hi-jacked I got over 1,000 a day
had to delete the email address and re-open it
Lorna McArdle
Tel/Fax: 0118 37...
Re: FN-FORUM: New Website Wanted
date posted 23rd July 2007 22:21
:)
From: "Punters Power"
>
> that was only a matter of time i should have waited before posting !
>
>
>
>
>
> ----- Original Message -----
> From: "Anna Ridley" [EMAIL REMOVED]
> To: [EMAIL REMOVED...
RE: FN-FORUM: 2 Servers - 4 NICs
date posted 23rd July 2007 22:18
>I believe Nic is suggesting that the two Gigabit cards be plugged in
>back-to-back.
>Nic, in Unixland getting the data over the gigabit route starts by typing
"man route" at the command line.
The...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 22:07
> Graham,
>
> Not exactly sure what you mean.
>
> Imagine Ive got a postcode SW..., I will know in PHP script by parsing
> first char that I have to search in specific table which will not
> contai...
Re: FN-FORUM: New Website Wanted
date posted 23rd July 2007 22:06
that was only a matter of time i should have waited before posting !
----- Original Message -----
From: "Anna Ridley" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Monday, July 23, 2007 8:56 PM
Subj...
Re: FN-FORUM: New Website Wanted
date posted 23rd July 2007 22:02
I bet you have a budget of around 10k right! Or is it a show string budget!
Andrew
----- Original Message -----
From: "Anna Ridley" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Monday, July 23, 2007 8...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 22:02
On Monday 23 July 2007 23:11:29 Juraj Seffer wrote:
> Graham,
>
> Not exactly sure what you mean.
>
> Imagine Ive got a postcode SW..., I will know in PHP script by parsing
> first char that I have to...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 22:00
On Monday 23 July 2007 22:52:40 Juraj Seffer wrote:
> Because if I search for postcode "SW13 5JL", I know that I have to
> search in table where I have postcodes from say O-S? Less rows to
> index and...
RE: FN-FORUM: Spams methods changing
date posted 23rd July 2007 21:57
Many thanks for your suggestions as this is ongoing and a pain
Regards,
John
-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of
Anthony Cartmell
Sent: 23 July 2007 22:04...
Re: FN-FORUM: New Website Wanted
date posted 23rd July 2007 21:54
On Monday 23 July 2007 21:55:52 Anna Ridley wrote:
> I'm looking at between =A3800 - =A31000 really. I'm on a tight budget!
Then your best bet is probably getting a designer to skin a free PHP script...
Re: FN-FORUM: Spams methods changing
date posted 23rd July 2007 21:51
On Monday 23 July 2007 22:21:27 Martin Wilkins wrote:
> I am also getting these, now I see everyone else is getting them on this
> forum I can see we have ourselves a sell out or someone has got a vi...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 21:48
Graham,
Not exactly sure what you mean.
Imagine Ive got a postcode SW..., I will know in PHP script by parsing
first char that I have to search in specific table which will not
contain all 27 M rows...
Re: FN-FORUM: Spams methods changing
date posted 23rd July 2007 21:40
> I'm getting these bounced mail / failed delivery as though I sent them
> and I didn't. How can I clear it?
See if you can set up SPF records for your e-mail domain. That will help
domains that ch...
Re: FN-FORUM: Spams methods changing
date posted 23rd July 2007 21:37
John Kelly wrote:
> I'm getting these bounced mail / failed delivery as though I sent them
> and I didn't. How can I clear it?
You're the victim of a Joe-Job
http://en.wikipedia.org/wiki/Joe_job...
Re: FN-FORUM: Spams methods changing
date posted 23rd July 2007 21:35
Anthony Cartmell wrote:
> According to the MailScanner list, the PDF spams are starting to become
> "old hat" now, and Excel spreadsheets are the next thing to be used...
Oh yes. I've been seeing th...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 21:33
Hi,
> Hi,
>
> It's actually postcode data. I guess I could split them by initial
> letters into say 3-4 parts / tables.
>
I don't see how splitting the database into two is going to help you. It
j...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 21:29
Because if I search for postcode "SW13 5JL", I know that I have to
search in table where I have postcodes from say O-S? Less rows to
index and search in, quicker query? Probably more stable database a...
RE: FN-FORUM: Spams methods changing
date posted 23rd July 2007 21:26
I'm getting these bounced mail / failed delivery as though I sent them
and I didn't. How can I clear it?
Regards,
-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Fade...
Re: FN-FORUM: Spams methods changing
date posted 23rd July 2007 21:24
> The next version of spamassassin (or whatever other spam filter you use)
> will almost certainly include rules to catch them.
http://www.rulesemporium.com/plugins.htm has a recently-released PDFinf...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 21:22
On Monday 23 July 2007 21:09:41 Gary Short wrote:
> Juraj Seffer wrote:
> > Evening all,
> >
> > Im working on a project where I would need to insert approx 26,700,000
> > (26.7 M) rows into one table...
RE: FN-FORUM: Spams methods changing
date posted 23rd July 2007 21:10
yes me too, quite a few of these parasite emails....
Freelance Software Developer
___________________________________________________________
Yahoo! Answers - Got a question? Someone out t...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 21:08
Sounds like Royal Mail PAF which I am dealing with. Thanks, should work OK then.
Jay
On 23 Jul 2007 20:13:51 -0000, Tom Miller [EMAIL REMOVED] wrote:
>
> Jay,
>
> I have a postcode database runnin...
Re: FN-FORUM: Spams methods changing
date posted 23rd July 2007 20:58
im getting a ton too. was great though was when someone hijacked my
domain last week and spoofed about 1000 emails that mostly all
bounced back to me. good times. heh.
On 23 Jul 2007, at 21:12, g...
Re: FN-FORUM: Spams methods changing
date posted 23rd July 2007 20:57
I am also getting these, now I see everyone else is getting them on this
forum I can see we have ourselves a sell out or someone has got a virus of
some kind rounding up all their e-mail address'....
RE: FN-FORUM: Spams methods changing
date posted 23rd July 2007 20:56
Got them ones as well, as if I need Viagra at my time of life, only 17 lol .
Chris
-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Juraj
Seffer
Sent: 23 July 2007 21:08...
Re: FN-FORUM: Spams methods changing
date posted 23rd July 2007 20:52
Yeah I had them too for about 4 days until my spam filter "adapted" :)
Chris Hanson wrote:
> I've had those to m8 best to ignore and add the spam / junk mail list in
> email client.
>
> Chris
>
> ---...
Re: FN-FORUM: Spams methods changing
date posted 23rd July 2007 20:50
Aidan wrote:
> Is anyone else getting spam in the form of pdf attachments? I've had 5 this
> week and an email pointing me to an ecard which ended up being a link to an
> executable containing the My...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 20:49
Jay,
I have a postcode database running in MySQL. It is 8GB in total and the
postcodes table has 27,500,000 records. Works absolutely fine on medium
spec machine.
Hope that helps.
Tom.
Juraj Se...
RE: FN-FORUM: Spams methods changing
date posted 23rd July 2007 20:48
I'm getting about 20 - 25 of these a day, no joke
Pain in the ass...
-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Thomas
Sent: Monday, July 23, 2007 3:06 PM
To: FN...
Re: FN-FORUM: Spams methods changing
date posted 23rd July 2007 20:44
Getting lots of blank emails with .pdf attachments these days. The
last one I opened was just a pic with Viagra, Cialis ... text on it.
Jay
On 23 Jul 2007 19:59:53 -0000, Aidan [EMAIL REMOVED] wro...
RE: FN-FORUM: Spams methods changing
date posted 23rd July 2007 20:44
I've had those to m8 best to ignore and add the spam / junk mail list in
email client.
Chris
-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Aidan
Sent: 23 July 2007 20...
Re: FN-FORUM: Spams methods changing
date posted 23rd July 2007 20:41
> Is anyone else getting spam in the form of pdf attachments? I've had 5
> this
> week and an email pointing me to an ecard which ended up being a link to
> an
> executable containing the Mytob.gen...
FN-FORUM: Spams methods changing
date posted 23rd July 2007 20:35
Is anyone else getting spam in the form of pdf attachments? I've had 5 this
week and an email pointing me to an ecard which ended up being a link to an
executable containing the Mytob.gen virus. The...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 20:34
Hi,
It's actually postcode data. I guess I could split them by initial
letters into say 3-4 parts / tables.
Thanks
Jay
On 23 Jul 2007 19:10:17 -0000, Gary Short [EMAIL REMOVED] wrote:
>
> Juraj...
Re: FN-FORUM: New Website Wanted
date posted 23rd July 2007 20:32
I'm looking at between £800 - £1000 really. I'm on a tight budget!
>From: Dom Latter [EMAIL REMOVED]
>Reply-To: [EMAIL REMOVED]
>To: "FN-FORUM / [EMAIL REMOVED] [EMAIL REMOVED]
>Subject: Re: FN-FO...
Re: FN-FORUM: New Website Wanted
date posted 23rd July 2007 20:13
On Monday 23 July 2007 21:10:22 Anna Ridley wrote:
> Bascially it's an online shoe business and will be (at the moment) the only
> way to sell the products, so getting it right is crucial
>
> I'm loo...
Re: FN-FORUM: New Website Wanted
date posted 23rd July 2007 20:08
Sounds a very sensable plus some one to do the marketing unless you can do
that yourself. There is the Search Engine Optimisation aswell.
Pam...
Re: FN-FORUM: New Website Wanted
date posted 23rd July 2007 20:01
Well I'm a designer not a developer by trade, I do build sites but only
xhtml & css, not there yet with the php or which ever language you choose. I
would recomend a designer and developer working t...
Re: FN-FORUM: New Website Wanted
date posted 23rd July 2007 19:58
Thanks!
>From: Upper Edge Media [EMAIL REMOVED]
>Reply-To: [EMAIL REMOVED]
>To: "FN-FORUM / [EMAIL REMOVED] [EMAIL REMOVED]
>Subject: Re: FN-FORUM: New Website Wanted
>Date: 23 Jul 2007 19:18:06 -00...
Re: FN-FORUM: New Website Wanted
date posted 23rd July 2007 19:55
Hi Anna,
Id agree with Dom that this probably isnt the best place to
ask for a recommendation, I would ask specifically for people with
experience in building and marketing e-commerce...
Re: FN-FORUM: New Website Wanted
date posted 23rd July 2007 19:46
Hi Dom
Thanks for getting in touch.
I should have put more detail on really.
I am looking for the whole design and build of the website and I haven't got
a logo yet either.
Bascially it's an onli...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 19:46
Juraj Seffer wrote:
> Evening all,
>
> Im working on a project where I would need to insert approx 26,700,000
> (26.7 M) rows into one table using MySQL.
Sounds to me like you need to horizontally...
Re: FN-FORUM: New Website Wanted
date posted 23rd July 2007 19:39
On Monday 23 July 2007 20:51:40 Anna Ridley wrote:
> Hi
>
> I am looking to get a new website built in the near future for my new
> business.
>
> Could anyone recommend an affordable and reilable comp...
Re: FN-FORUM: New Website Wanted
date posted 23rd July 2007 19:31
I would recomend me. Would be nice if someone could second that, maybe ask
my clients.
Martin
www.atdc.co.uk
----- Original Message -----
From: "Anna Ridley" [EMAIL REMOVED]
To: [EMAIL REMOVED]
S...
FN-FORUM: New Website Wanted
date posted 23rd July 2007 19:28
Hi
I am looking to get a new website built in the near future for my new
business.
Could anyone recommend an affordable and reilable company?
Many thanks
Anna
___________________________________...
Re: FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 19:04
Hi Jay,
According to mysql.com, the software should easily handle that amount of
rows [1], performance wise of course that is solely down to your hardware.
Experience says that if it's indexed on th...
FN-FORUM: How many rows can MySQL handle?
date posted 23rd July 2007 18:36
Evening all,
Im working on a project where I would need to insert approx 26,700,000
(26.7 M) rows into one table using MySQL. I will search by two columns
(4 and 3 chars long) which will be indexed....
Re: FN-FORUM: MySQL/PHP question
date posted 23rd July 2007 18:27
On Monday 23 July 2007 17:49:28 David Long wrote:
> Dom Latter wrote:
> > On Monday 23 July 2007 10:07:02 ah ah wrote:
> >> SELECT TOP 4 OrderPrice
> >
> > What flavour of SQL is that?
>
> SQL Ser...
Re: FN-FORUM: Advanced fee scam
date posted 23rd July 2007 18:24
On Monday 23 July 2007 18:49:34 Bill Westhead wrote:
> Whilst the police may not acknowledge each report sent via email, they
> are all collated by police staff. An officer may not actively
> investi...
Re: FN-FORUM: Advanced fee scam
date posted 23rd July 2007 17:26
Whilst the police may not acknowledge each report sent via email, they
are all collated by police staff. An officer may not actively
investigate the case, but it will be recorded in crime reporting
st...
Re: FN-FORUM: MySQL/PHP question
date posted 23rd July 2007 16:26
Dom Latter wrote:
> On Monday 23 July 2007 10:07:02 ah ah wrote:
>
>> SELECT TOP 4 OrderPrice
>>
>
> What flavour of SQL is that?
>
SQL Server and Access use the TOP N syntax instead o...
Re: FN-FORUM: Advanced fee scam
date posted 23rd July 2007 16:15
On Monday 23 July 2007 17:00:10 Martin Wilkins wrote:
> Hello everyone
>
> today I received a classic example of the Advance fee scam, today's
> culprits are Jewellers in Hong Kong ;) I would like to...
FN-FORUM: Advanced fee scam
date posted 23rd July 2007 15:36
Hello everyone
today I received a classic example of the Advance fee scam, today's culprits
are Jewellers in Hong Kong ;) I would like to report this so does anyone
know where the best place is to...
Re: FN-FORUM: MySQL/PHP question
date posted 23rd July 2007 09:48
On Monday 23 July 2007 10:07:02 ah ah wrote:
> hello,
>
> If you want to show only say top 4 rows
> use something like
> SELECT TOP 4 OrderPrice
What flavour of SQL is that?...
Re: FN-FORUM: Get A Freelancer
date posted 23rd July 2007 09:22
To be honest, Freelancers.net is the only site I bother with these days.
Either the bids are outrageously low or you have to pay a load of extras
to be "seen". Which one could say is fair enough, bu...
RE: FN-FORUM: MySQL/PHP question
date posted 23rd July 2007 09:16
Cheers Neil, yep I managed to find that one last night, in fact almost as
soon as I'd sent the email lol.
It's all part of the learning curve :)
Thanks for your help, its appreciated.
Allan
-----...
RE: FN-FORUM: WYSIWYG style web based css2 editor
date posted 23rd July 2007 09:07
Quoting "Sam M - www.wiredeyes.com" [EMAIL REMOVED]
> I think the two first replies didn't quite read or understand the subject =
or
> content of my email fully.
>
> What I'm looking for is a "WEB" b...
Re: FN-FORUM: MySQL/PHP question
date posted 23rd July 2007 09:04
Sam M - www.wiredeyes.com wrote:
> In mySQL it would be
>
> SELECT OrderPrice
> FROM Orders
> LIMIT 4
> Order by OrderPrice DESC
Actually, the order of the clauses is important - LIMIT mus...
RE: FN-FORUM: MySQL/PHP question
date posted 23rd July 2007 08:54
In mySQL it would be
SELECT OrderPrice
FROM Orders
LIMIT 4
Order by OrderPrice DESC
Regards
Sam Morgan
WiredEyes Media / ServWise Advanced Hosting
tel (Uk): +44 (0)20 7100 2178
tel (Ita...
Re: FN-FORUM: Get A Freelancer
date posted 23rd July 2007 08:52
On 23 Jul 2007, at 09:04, Sam M - www.wiredeyes.com wrote:
>
> I think people who "recommended" that site were being sarcastic. =20
> It=92s a pile
> of trash IMHO.
That's pretty much the conclusio...
Re: FN-FORUM: MySQL/PHP question
date posted 23rd July 2007 08:51
Lists@ wrote:
> Now all I need to do is randomise the results but not allow the same product
> to be displayed!
Put "ORDER BY RAND()" before the limit clause - you'll find you won't
get duplicate pr...
RE: FN-FORUM: MySQL/PHP question
date posted 23rd July 2007 08:49
Hi there,
Thanks for the reply. I got it all sorted last night.
Regards
Allan
-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of ah ah
Sent: 23 July 2007 09:07
To: FN-F...
Re: FN-FORUM: MySQL/PHP question
date posted 23rd July 2007 08:43
hello,
If you want to show only say top 4 rows
use something like
SELECT TOP 4 OrderPrice
FROM Orders
Order by OrderPrice DESC
or
If you want to show only say lowest 4 rows
use somet...
RE: FN-FORUM: Get A Freelancer
date posted 23rd July 2007 08:41
> -----Original Message-----
>=20
> I've seen getafreelancer.com recommended on this list so I signed up.
>=20
> It all looks fine except for the low, low bids. In some instances
> I've seen people of...
FN-FORUM: Get A Freelancer
date posted 23rd July 2007 08:13
I've seen getafreelancer.com recommended on this list so I signed up.
It all looks fine except for the low, low bids. In some instances =20
I've seen people offering to work for around =A32 an hour....
Re: FN-FORUM: WYSIWYG style web based css2 editor
date posted 23rd July 2007 07:22
On 23 Jul 2007, at 07:04, Sam M - www.wiredeyes.com wrote:
> Neither am I looking for a
> "WYSIWYM" html editor, because I actually WANT to give the user as
> much
> power to change things as pos...
RE: FN-FORUM: WYSIWYG style web based css2 editor
date posted 23rd July 2007 06:40
I think the two first replies didn't quite read or understand the subject or
content of my email fully.
What I'm looking for is a "WEB" based CSS editor, not an PC application (or
Mac, god forbid, op...
RE: FN-FORUM: MySQL/PHP question
date posted 23rd July 2007 00:26
Hi Neil,
Thanks for the reply, works perfectly.
Now all I need to do is randomise the results but not allow the same product
to be displayed!
Allan
-----Original Message-----
From: [EMAIL REMOVED...
Re: FN-FORUM: MySQL/PHP question
date posted 23rd July 2007 00:02
hello,
If you want to show only say top 4 rows
use something like
SELECT TOP 4 OrderPrice
FROM Orders
Order by OrderPrice DESC
or
If you want to show only say lowest 4 rows
use somet...
|
|