Steve Vernon [mailto:steve;extremewattage.co.uk] wrote:
Hiya,
Just wondering what is the rough idea of speed of a
server like this is
holding a database with millions of records. I know its
difficult, depends
on the data stored etc.
Its basically storing an index int and about
hey guys.
new to php mySql
how would i move a db from a test server to a production sever?
would it just be C:\mysql\data\testC:\mysql\data\thisProductionDir
would i just copy thisProductionDir or is there a better way?
oh i wanted to know about how to set up a odbc data source with mySql,
I think that if your mySQL DB is planned to be 10M records, you might as
well move it now to pgSQL and wait for that size - pgSQL will make it
better than mySQL on these sizes.
I personally don't understand, how it comes into some minds using mySQL
for database larger than n millions of records?
Well, you are gonna have to do two queries if you want a dynamic number of
questions in each poll, unless you want to do something limited and have
10 to 20 columns for each poll and leave the questions not questioned
null... IE:
table poll
pollid
name
descr
question1
question2
question3
Hi there,
I got this fustrating problem with postgresql php can any one help???
my postgresql installation is working fine with my perl application. My php
is working fine... however, my php don't seems to be able to connect to the
postgresql. I always get the unable to connect error...
Well, I don't know specifics of postgresql, but I'll give it a whirl.
http://www.php.net/manual/en/function.pg-last-error.php
This function should give you the error about WHY it was unable to connect.
If not, check stuff like permissions, making sure pgsql.so (or whatever it
is named) is
did you try select max(v) as max_v from your_table where year=... ?
and put this query in a loop for years.
mihai
On Sun, 10 Nov 2002, Martin Allan Jensen wrote:
Hi evryonei have a problem that i hope you can help me with.
Here it goes!
I have two arrays returned from my DB one called