473,322 Members | 1,493 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

php/MySQL index filing?

Does anyone here open a second MySQL database and use that as a straight
IDX type file that points to the record number in the main database, for
speed's sake?

Some time ago I'd set up a standard php login routine and hit a brick
wall as then found out that my host didn't allow external login's (at
that time) with MySQL (true!) so I got around it by writing a random
access database with separate IDX files for username and passwords for
cross-referencing.

Things have all changed and the php/MySQL setup is as standard, so I
have to rewrite the checking routines which leaves me to wonder if
others use a second MySQL database as an Index file for any reason or is
it all fast enough using one database?

Or even, is there any point changing at all?

Many thanks,
Richard.
Oct 20 '07 #1
13 2268
Richard Brooks wrote:
Does anyone here open a second MySQL database and use that as a straight
IDX type file that points to the record number in the main database, for
speed's sake?

Some time ago I'd set up a standard php login routine and hit a brick
wall as then found out that my host didn't allow external login's (at
that time) with MySQL (true!) so I got around it by writing a random
access database with separate IDX files for username and passwords for
cross-referencing.

Things have all changed and the php/MySQL setup is as standard, so I
have to rewrite the checking routines which leaves me to wonder if
others use a second MySQL database as an Index file for any reason or is
it all fast enough using one database?

Or even, is there any point changing at all?

Many thanks,
Richard.
And what does this have to do with PHP? If you want a good answer about
MySQL, try a MySQL newsgroup - such as comp.databases.mysql. That's
where the MySQL experts hang out, not here.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Oct 20 '07 #2
Jerry Stuckle said the following on 20/10/2007 14:22:
Richard Brooks wrote:
>Does anyone here open a second MySQL database and use that as a
straight IDX type file that points to the record number in the main
database, for speed's sake?

Some time ago I'd set up a standard php login routine and hit a brick
wall as then found out that my host didn't allow external login's (at
that time) with MySQL (true!) so I got around it by writing a random
access database with separate IDX files for username and passwords for
cross-referencing.

Things have all changed and the php/MySQL setup is as standard, so I
have to rewrite the checking routines which leaves me to wonder if
others use a second MySQL database as an Index file for any reason or
is it all fast enough using one database?

Or even, is there any point changing at all?

Many thanks,
Richard.

And what does this have to do with PHP? If you want a good answer about
MySQL, try a MySQL newsgroup - such as comp.databases.mysql. That's
where the MySQL experts hang out, not here.
Well, I've got my whole system written in MySQL-less PHP! Would that
help? And I would not believe that php'ers never even think of dabbling
in MySQL.

Oct 21 '07 #3
Richard Brooks wrote:
Jerry Stuckle said the following on 20/10/2007 14:22:
>Richard Brooks wrote:
>>Does anyone here open a second MySQL database and use that as a
straight IDX type file that points to the record number in the main
database, for speed's sake?

Some time ago I'd set up a standard php login routine and hit a brick
wall as then found out that my host didn't allow external login's (at
that time) with MySQL (true!) so I got around it by writing a random
access database with separate IDX files for username and passwords
for cross-referencing.

Things have all changed and the php/MySQL setup is as standard, so I
have to rewrite the checking routines which leaves me to wonder if
others use a second MySQL database as an Index file for any reason or
is it all fast enough using one database?

Or even, is there any point changing at all?

Many thanks,
Richard.

And what does this have to do with PHP? If you want a good answer
about MySQL, try a MySQL newsgroup - such as comp.databases.mysql.
That's where the MySQL experts hang out, not here.

Well, I've got my whole system written in MySQL-less PHP! Would that
help? And I would not believe that php'ers never even think of dabbling
in MySQL.

First of all, you didn't say that.

However, you're asking how to best structure MySQL files, not how to
program in PHP. For MySQL questions, I recommend a MySQL newsgroup.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Oct 21 '07 #4
Jerry Stuckle wrote:
Richard Brooks wrote:
>Jerry Stuckle said the following on 20/10/2007 14:22:
>>Richard Brooks wrote:
Does anyone here open a second MySQL database and use that as a
straight IDX type file that points to the record number in the main
database, for speed's sake?

Some time ago I'd set up a standard php login routine and hit a
brick wall as then found out that my host didn't allow external
login's (at that time) with MySQL (true!) so I got around it by
writing a random access database with separate IDX files for
username and passwords for cross-referencing.

Things have all changed and the php/MySQL setup is as standard, so I
have to rewrite the checking routines which leaves me to wonder if
others use a second MySQL database as an Index file for any reason
or is it all fast enough using one database?

Or even, is there any point changing at all?

Many thanks,
Richard.
And what does this have to do with PHP? If you want a good answer
about MySQL, try a MySQL newsgroup - such as comp.databases.mysql.
That's where the MySQL experts hang out, not here.

Well, I've got my whole system written in MySQL-less PHP! Would that
help? And I would not believe that php'ers never even think of
dabbling in MySQL.


First of all, you didn't say that.

However, you're asking how to best structure MySQL files, not how to
program in PHP. For MySQL questions, I recommend a MySQL newsgroup.
Why? because you have less of a clue about MySQL than PHP?
Oct 22 '07 #5
The Natural Philosopher wrote:
Jerry Stuckle wrote:
>Richard Brooks wrote:
>>Jerry Stuckle said the following on 20/10/2007 14:22:
Richard Brooks wrote:
Does anyone here open a second MySQL database and use that as a
straight IDX type file that points to the record number in the main
database, for speed's sake?
>
Some time ago I'd set up a standard php login routine and hit a
brick wall as then found out that my host didn't allow external
login's (at that time) with MySQL (true!) so I got around it by
writing a random access database with separate IDX files for
username and passwords for cross-referencing.
>
Things have all changed and the php/MySQL setup is as standard, so
I have to rewrite the checking routines which leaves me to wonder
if others use a second MySQL database as an Index file for any
reason or is it all fast enough using one database?
>
Or even, is there any point changing at all?
>
Many thanks,
>
>
Richard.
>

And what does this have to do with PHP? If you want a good answer
about MySQL, try a MySQL newsgroup - such as comp.databases.mysql.
That's where the MySQL experts hang out, not here.

Well, I've got my whole system written in MySQL-less PHP! Would that
help? And I would not believe that php'ers never even think of
dabbling in MySQL.


First of all, you didn't say that.

However, you're asking how to best structure MySQL files, not how to
program in PHP. For MySQL questions, I recommend a MySQL newsgroup.
Why? because you have less of a clue about MySQL than PHP?
Because this is a PHP newsgroup, stoopid. But you don't seem to
understand the difference.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Oct 22 '07 #6
Jerry Stuckle said the following on 21/10/2007 19:21:
Richard Brooks wrote:
>Jerry Stuckle said the following on 20/10/2007 14:22:
>>Richard Brooks wrote:
Does anyone here open a second MySQL database and use that as a
straight IDX type file that points to the record number in the main
database, for speed's sake?

Some time ago I'd set up a standard php login routine and hit a
brick wall as then found out that my host didn't allow external
login's (at that time) with MySQL (true!) so I got around it by
writing a random access database with separate IDX files for
username and passwords for cross-referencing.

Things have all changed and the php/MySQL setup is as standard, so I
have to rewrite the checking routines which leaves me to wonder if
others use a second MySQL database as an Index file for any reason
or is it all fast enough using one database?

Or even, is there any point changing at all?

Many thanks,
Richard.
And what does this have to do with PHP? If you want a good answer
about MySQL, try a MySQL newsgroup - such as comp.databases.mysql.
That's where the MySQL experts hang out, not here.

Well, I've got my whole system written in MySQL-less PHP! Would that
help? And I would not believe that php'ers never even think of
dabbling in MySQL.


First of all, you didn't say that.

However, you're asking how to best structure MySQL files, not how to
program in PHP. For MySQL questions, I recommend a MySQL newsgroup.
Okay! BTW, you'd better tell bill not to talk about MySQL TimeZone
support or just sing to yourself with fingers in your ears and there's
no use saying that it doesn't count as both this and his post includes
php usage.

I already have a php ONLY database setup with php IDX type flatfiles
with a file offset pointer in them. It was hard work but it does work.
[1]. Is there a point changing it over to that other type of database
(using php of course)?
[2]. If there is anyone using databases in php, do they use a main and
IDX files separately?
[3]. Using php, did your mother breast feed you at all?
Oct 22 '07 #7
Richard Brooks wrote:
Jerry Stuckle said the following on 21/10/2007 19:21:
>Richard Brooks wrote:
>>Jerry Stuckle said the following on 20/10/2007 14:22:
Richard Brooks wrote:
Does anyone here open a second MySQL database and use that as a
straight IDX type file that points to the record number in the main
database, for speed's sake?
>
Some time ago I'd set up a standard php login routine and hit a
brick wall as then found out that my host didn't allow external
login's (at that time) with MySQL (true!) so I got around it by
writing a random access database with separate IDX files for
username and passwords for cross-referencing.
>
Things have all changed and the php/MySQL setup is as standard, so
I have to rewrite the checking routines which leaves me to wonder
if others use a second MySQL database as an Index file for any
reason or is it all fast enough using one database?
>
Or even, is there any point changing at all?
>
Many thanks,
>
>
Richard.
>

And what does this have to do with PHP? If you want a good answer
about MySQL, try a MySQL newsgroup - such as comp.databases.mysql.
That's where the MySQL experts hang out, not here.

Well, I've got my whole system written in MySQL-less PHP! Would that
help? And I would not believe that php'ers never even think of
dabbling in MySQL.


First of all, you didn't say that.

However, you're asking how to best structure MySQL files, not how to
program in PHP. For MySQL questions, I recommend a MySQL newsgroup.

Okay! BTW, you'd better tell bill not to talk about MySQL TimeZone
support or just sing to yourself with fingers in your ears and there's
no use saying that it doesn't count as both this and his post includes
php usage.

I already have a php ONLY database setup with php IDX type flatfiles
with a file offset pointer in them. It was hard work but it does work.
[1]. Is there a point changing it over to that other type of database
(using php of course)?
Check in the newsgroups for the database(s) you're trying to use.
That's where database experts hang out.
[2]. If there is anyone using databases in php, do they use a main and
IDX files separately?
There are lots of people using databases in PHP. As for maintaining
separate files, ask in the newsgroups for the database(s) you're trying
to use. That's where database experts hang out.
[3]. Using php, did your mother breast feed you at all?
Sheesh. Try to give someone some help and they insult you.

What are you, a troll? You're asking about databases. Databases are
language neutral - they are used with a number of languages. But
obviously you don't understand that. So you need to go to a database
newsgroup to learn about it.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Oct 22 '07 #8
Jerry Stuckle wrote:
Richard Brooks wrote:
>
>[3]. Using php, did your mother breast feed you at all?

Sheesh. Try to give someone some help and they insult you.

What are you, a troll?
Everyone's a troll who disagrees with you, Jerry.
Oct 22 '07 #9
The Natural Philosopher wrote:
Jerry Stuckle wrote:
>Richard Brooks wrote:
>>
>>[3]. Using php, did your mother breast feed you at all?

Sheesh. Try to give someone some help and they insult you.

What are you, a troll?

Everyone's a troll who disagrees with you, Jerry.
No, just assholes like you.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Oct 22 '07 #10
Jerry Stuckle said the following on 22/10/2007 12:15:
Sheesh. Try to give someone some help and they insult you.
Sorry! I was busy reading all the stuff that comes up in Google with
"Jerry Stuckle Asshole" as the keyword phrase.
What are you, a troll? You're asking about databases. Databases are
language neutral - they are used with a number of languages. But
obviously you don't understand that. So you need to go to a database
newsgroup to learn about it.
But using them within a php environment is the important part and as php
is the language (okay, it's good old C really) being used and people who
have written them would be lurking around here, they would know of any
pitfalls in using a 'roll your own' method.

Now, go outside and play if the other parents will let you play with
their children. It'll do you some good to get a bloody nose and have
your lunch money stolen sometimes.

Oct 23 '07 #11
Richard Brooks wrote:
Jerry Stuckle said the following on 22/10/2007 12:15:
>Sheesh. Try to give someone some help and they insult you.

Sorry! I was busy reading all the stuff that comes up in Google with
"Jerry Stuckle Asshole" as the keyword phrase.
>What are you, a troll? You're asking about databases. Databases are
language neutral - they are used with a number of languages. But
obviously you don't understand that. So you need to go to a database
newsgroup to learn about it.

But using them within a php environment is the important part and as php
is the language (okay, it's good old C really) being used and people who
have written them would be lurking around here, they would know of any
pitfalls in using a 'roll your own' method.

Now, go outside and play if the other parents will let you play with
their children. It'll do you some good to get a bloody nose and have
your lunch money stolen sometimes.

First of all, it's not "Good Old C". This is PHP.

Second of all, you obviously have no understanding of how RDB's work. I
assumed since you "wrote your own database" you would at least have
*SOME* inkling how they work. But obviously you have *none*.

And no, most people in this group are smarter than to try to "roll your
own". Obviously you're not that smart.

I tried to give you some good advice. You came back with insults.

Here's one more try. Learn how *REAL* databases work. Then come back
when you can ask *intelligent* questions.

Or learn to take good advice.

And by the way - sure, you can find some negative things about me.
That's because I don't put up with assholes like you. And I'm not
afraid to tell you that.

Now, you're mommy's calling. Better go see what she wants.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Oct 23 '07 #12
Jerry Stuckle said the following on 23/10/2007 14:10:
Richard Brooks wrote:
>Jerry Stuckle said the following on 22/10/2007 12:15:
>>Sheesh. Try to give someone some help and they insult you.

Sorry! I was busy reading all the stuff that comes up in Google with
"Jerry Stuckle Asshole" as the keyword phrase.
>>What are you, a troll? You're asking about databases. Databases are
language neutral - they are used with a number of languages. But
obviously you don't understand that. So you need to go to a database
newsgroup to learn about it.

But using them within a php environment is the important part and as
php is the language (okay, it's good old C really) being used and
people who have written them would be lurking around here, they would
know of any pitfalls in using a 'roll your own' method.

Now, go outside and play if the other parents will let you play with
their children. It'll do you some good to get a bloody nose and have
your lunch money stolen sometimes.


First of all, it's not "Good Old C". This is PHP.
History

PHP was written as a set of Common Gateway Interface (CGI) binaries in
the C programming language by the Danish/Greenlandic programmer Rasmus
Lerdorf in 1994, to replace a small set of Perl scripts he had been
using to maintain his personal homepage.[3] Lerdorf initially created
PHP to display his résumé and to collect certain data, such as how much
traffic his page was receiving. Personal Home Page Tools was publicly
released on 8 June 1995 after Lerdorf combined it with his own Form
Interpreter to create PHP/FI (this release is considered PHP version 2).[4]
Second of all, you obviously have no understanding of how RDB's work. I
assumed since you "wrote your own database" you would at least have
*SOME* inkling how they work. But obviously you have *none*.

And no, most people in this group are smarter than to try to "roll your
own". Obviously you're not that smart.
Onideus, is that you?
Oct 23 '07 #13
Richard Brooks wrote:
Jerry Stuckle said the following on 23/10/2007 14:10:
>Richard Brooks wrote:
>>Jerry Stuckle said the following on 22/10/2007 12:15:

Sheesh. Try to give someone some help and they insult you.

Sorry! I was busy reading all the stuff that comes up in Google with
"Jerry Stuckle Asshole" as the keyword phrase.

What are you, a troll? You're asking about databases. Databases
are language neutral - they are used with a number of languages.
But obviously you don't understand that. So you need to go to a
database newsgroup to learn about it.

But using them within a php environment is the important part and as
php is the language (okay, it's good old C really) being used and
people who have written them would be lurking around here, they would
know of any pitfalls in using a 'roll your own' method.

Now, go outside and play if the other parents will let you play with
their children. It'll do you some good to get a bloody nose and have
your lunch money stolen sometimes.


First of all, it's not "Good Old C". This is PHP.

History

PHP was written as a set of Common Gateway Interface (CGI) binaries in
the C programming language by the Danish/Greenlandic programmer Rasmus
Lerdorf in 1994, to replace a small set of Perl scripts he had been
using to maintain his personal homepage.[3] Lerdorf initially created
PHP to display his résumé and to collect certain data, such as how much
traffic his page was receiving. Personal Home Page Tools was publicly
released on 8 June 1995 after Lerdorf combined it with his own Form
Interpreter to create PHP/FI (this release is considered PHP version 2).[4]
So? Linux was basically written in C. That doesn't make it essentially
a C programming language. And the same can be said for most of Windows.

Come to think of it, I think most of VBScript.NET is written in C. Does
that make it basically a C language, also? How about Excel? Or Open
Office?

Just because something was written in C doesn't mean it is basically C.

>Second of all, you obviously have no understanding of how RDB's work.
I assumed since you "wrote your own database" you would at least have
*SOME* inkling how they work. But obviously you have *none*.

And no, most people in this group are smarter than to try to "roll
your own". Obviously you're not that smart.

Onideus, is that you?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Oct 23 '07 #14

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Duncan Smith | last post by:
Hello, I'm not very experienced in SQL and I need some advice. I have a comma separarated values file containing around 20 million records and about 20 fields. There are many missing values...
6
by: jacob nikom | last post by:
I would like to create data model for a group of stores. All stores in this group are very similar to each other, so it is natural to allocate one MySQL database per store. Each database is going...
2
by: Tarbuza Smith | last post by:
I was told that it is easy to create a table in MYSQL but it is hard to create a table with relationship like in Oracle or SQL Server by using Relationship or Query by Design or whatever wysiwyg...
16
by: Skip Montanaro | last post by:
I'm struggling to get a handle on a slow query problem. I'm running 3.23.41. Here's an entry from the slow log file. # Time: 031006 15:15:43 # User@Host: concerts @ localhost # Time: 173 ...
12
by: jacob nikom | last post by:
Hi, I would like to store XML files in MySQL. What is the best solution: 1. Convert it to string and store it as CLOB/text 2. Serialize it and store as byte array 3. Flatten it out and create...
2
by: JP | last post by:
My company is considering acquisition of a packaged application that's based on My SQL. This would be our first use of MySQL and the CEO is worried about using a "no-name" database (he's a...
7
by: Michael C# | last post by:
Is it possible to create Dynamic SQL queries in MySQL, like in SQL Server? i.e., the EXECUTE command or sp_executesql stored procedure in SQL Server. TIA
2
by: Thanos | last post by:
Hello all, can someone advice me some links/infos on how to optimize MySQL server to execute very complex queries ? My configuration is as follows : P4 2.8Ghz/512MB running on Fedora Core 1...
221
Atli
by: Atli | last post by:
You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t. In situations where your PHP application...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.