php / MySQL索引归档? [英] php/MySQL index filing?

查看:103
本文介绍了php / MySQL索引归档?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

这里是否有人打开第二个MySQL数据库,并将其用作直接

IDX类型文件,指向主数据库中的记录号,

speed'好吧?


前段时间我已经设置了一个标准的php登录例程并点砖了

墙,然后发现我的主机使用MySQL不允许外部登录(在那个时候是

)(真的!)所以我通过编写随机的

访问数据库来解决这个问题用于

交叉引用的用户名和密码的IDX文件。


事情已全部改变,php / MySQL设置为标准,所以我
必须重写检查程序,这让我不知道是否其他人因为任何原因使用第二个MySQL数据库作为索引文件,或者

全部使用一个数据库的速度是否足够快?


甚至,是否有任何变化点?


非常感谢,

Richard。

解决方案

Richard Brooks写道:


这里是否有人打开第二个MySQL数据库并将其用作直接的

IDX类型文件指向主数据库中的记录号,对于

speed'的缘故?


前段时间我' 'd设置一个标准的php登录例程并点击一块砖

墙,然后发现我的主机不允许外部登录'(

那个时间)与MySQL(真的!)所以我通过编写一个随机的

访问数据库来解决这个问题,该数据库包含用于

交叉引用的用户名和密码的单独IDX文件。 />

事情都发生了变化,php / MySQL的设置也是标准配置,所以我要b / b
必须重写检查程序,这让我不知道是否

其他人出于任何原因使用第二个MySQL数据库作为索引文件,或者使用一个数据库是否足够快?


甚至,是的是否有任何变化?


非常感谢,


理查德。



这与PHP有什么关系?如果你想要一个关于

MySQL的好答案,试试一个MySQL新闻组 - 比如comp.databases.mysql。这是'

,MySQL专家在这里闲逛,而不是在这里。


-

====== ============

删除x来自我的电子邮件地址

Jerry Stuckle

JDS计算机培训公司
js ******* @ attglobal.net

==================


Jerry Stuckle在20/10/2007 14:22发表以下内容:


Richard Brooks写道:


>这里是否有人打开第二个MySQL数据库并将其用作指向主要记录号的直接IDX类型文件
数据库,为了速度的缘故?

前段时间我会设置一个标准的php登录例程并打砖墙,然后发现我的主人没有'''允许使用MySQL进行外部登录(在那个时间)(真的!)所以我通过编写一个随机的访问数据库和单独的用户名和密码的IDX文件来解决这个问题。
交叉引用。

事情都发生了变化,php / MySQL设置就像stan一样dard,所以我必须重写检查程序,这让我不知道其他人是否因为任何原因使用第二个MySQL数据库作为索引文件,或者
使用一个数据库是否足够快?

甚至,是否有任何改变点?

非常感谢,

Richard。



这与PHP有什么关系?如果你想要一个关于

MySQL的好答案,试试一个MySQL新闻组 - 比如comp.databases.mysql。那是MySQL专家在哪里闲逛,而不是在这里。



好​​吧,我的整个系统都是用无PHP的PHP编写的!那个

会有帮助吗?而且我不相信php''ers甚至从未想过在MySQL中涉及到



Richard Brooks写道:


Jerry Stuckle在20/10/2007 14:22发表以下内容:


> Richard Brooks写道:


>>这里是否有人打开第二个MySQL数据库并将其用作指向记录号的直接IDX类型文件为了速度,主要的数据库?

前段时间我已经设置了一个标准的php登录例程并打了砖墙然后发现了我的主持人不允许使用MySQL进行外部登录(在那个时间)(真的!)所以我通过编写一个随机的访问数据库和单独的用户名IDX文件来解决这个问题。密码
用于交叉引用。

事情都发生了变化,php / MySQL的设置也是标准的,所以我有
重写检查例程让我不知道其他人是否出于任何原因使用第二个MySQL数据库作为索引文件,或者使用一个数据库是否足够快?

或者甚至,是否有任何改变点?

非常感谢,

理查德。


这有什么用用PHP做什么?如果你想要一个关于MySQL的好答案,试试一个MySQL新闻组 - 比如comp.databases.mysql。
这就是MySQL专家在这里闲逛的地方,而不是这里。



好​​吧,我的整个系统都是用无PHP的PHP编写的!那个

会有帮助吗?而且我不相信php''ers甚至从未想过在MySQL中涉足





首先,你没有这么说。


但是,你问的是如何最好地构建MySQL文件,而不是如何在PHP中使用
程序。对于MySQL问题,我推荐一个MySQL新闻组。


-

==================

删除x来自我的电子邮件地址

Jerry Stuckle

JDS计算机培训公司
js ******* @ attglobal.net

==================


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.

解决方案

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
==================


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.


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
==================


这篇关于php / MySQL索引归档?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆