数据库建议 [英] Database suggestion
问题描述
嗨。
我使用PHP中10-20级的递归数组树。到目前为止我已经使用serialize()来存储数组,生成文件5+
MB大,需要10-15秒来反序列化和大约10倍
RAM!我被建议使用MySQL(关系数据库),但除了那个和var_export / include之外还有其他选项吗?
的工作原理与MySQL类似,在添加新元素时没有
加载整个数据库本身...
谢谢!
Mikhail Kovalev写道:
我被告知过使用MySQL(关系数据库),但除了那个和var_export / include之外还有其他选项吗?在没有加载
整个数据库本身的情况下添加新元素时,以与MySQL类似的方式工作的东西是
...
SQLite,PostgreSQL,Oracle,Microsoft SQL Server,...
-
Toby A Inkster BSc(荣誉)ARCS
[Geek of HTML / SQL / Perl / PHP / Python / Apache / Linux]
[操作系统:Linux 2.6.17.14-mm-desktop-9mdvsmp,最多10天,18 :31。]
与Apple iTunes分享音乐
http://tobyinkster.co.uk/blog/2007/1...tunes-sharing/
我的意思是,我不介意使用MySQL本身,只是因为我不想要b $ b想要使用关系数据库。
我不知道是否有可能预定义我在MySQL中使用
的结构,因为级别的数量不同等等。
以下是记录单个序列o的示例f 6元素:
如何将其放入数据库?
数组(
0 => ;
数组(
0 = 2,
1 =>
数组(
1 =>
数组(
0 = 1,
1 =>
数组(
),
),
2 =>
数组(
0 = 1,
1 =>
数组(
3 =>
数组(
0 = 1,
1 =>
数组(
4 =>
数组(
0 = 1,
1 =>
数组(
3 => ;
数组(
0 = 1,
1 =>
数组(
1 =>
数组(
0 = 1,
1 =>
数组(
),
),
),
),
) ,
),
),
),
),
) ,
),
),
1 =>
阵列(
0 = 2,
1 =>
数组(
),
),
2 =>
数组(
0 = 1,
1 =>
数组(
3 => ;
数组(
0 = 1,
1 =>
数组(
4 =>
数组(
0 = 1,
1 =>
数组(
3 =>
数组(
0 = 1,
1 =>
数组(
1 =>
数组(
0 = 1,
1 =>
数组(
),
),
),
),
),
),
),
),
),
),
3 =>
数组(
0 = 2,>
1 =>
数组(
4 =>
数组(
0 = 1,
1 =>
数组(
3 =>
数组(
0 = 1,
1 =>
数组(
1 =>
阵列(
0 = 1,
1 =>
数组(
),
),
),
),
),
),
1 =>
数组(
0 = 1,
1 =>
数组(
),
),
),
),
4 =>
数组(
0 = 1,
1 =>
数组(
3 =>
数组(
0 = 1,
1 =>
数组(
1 =>
数组(
0 = 1,
1 =>
数组(
),
),
),
),
),
),
)
On 5 Des,12:42,Toby A Inkster< usenet200 ... @ tobyinkster.co.uk>
写道:
Mikhail Kovalev写道:
我去过建议使用MySQL(关系数据库),但除了那个和var_e之外还有其他选项吗? XPORT /包括哪些内容?在没有加载
整个数据库本身的情况下添加新元素时,以与MySQL类似的方式运行的东西是
...
SQLite,PostgreSQL,Oracle,Microsoft SQL Server,...
-
Toby A Inkster BSc(荣誉)ARCS
[Geek of HTML / SQL / Perl / PHP / Python / Apache / Linux]
[操作系统:Linux 2.6.17.14-mm-desktop-9mdvsmp,最多10天,18 :31。]
与Apple iTunes分享音乐
http://tobyinkster.co.uk/blog/2007/1...tunes-sharing/
Mikhail Kovalev写道:
嗨。
我使用10-20级的递归数组树用PHP。到目前为止我已经使用serialize()来存储数组,生成文件5+
MB大,需要10-15秒来反序列化和大约10倍
RAM!我被建议使用MySQL(关系数据库),但除了那个和var_export / include之外还有其他选项吗?
的工作原理与MySQL类似,在添加新元素时没有
加载整个数据库本身...
谢谢!
你是什么意思没有加载整个数据库本身?
-
==================
删除x来自我的电子邮件地址
Jerry Stuckle
JDS计算机培训公司
js ******* @ attglobal.net
==================
Hi.
I work with recursive array trees of 10-20 levels in PHP. So far I
have been using serialize() to store the arrays, generating files 5+
MB large, which take 10-15 seconds to unserialize and about tenfold of
RAM! I''ve been adviced to use MySQL (relational db''s), but are there
any other options beside that and var_export/include? Something that
works in a similar way as MySQL when adding a new element without
loading the whole database itself...
Thanks!
Mikhail Kovalev wrote:
I''ve been adviced to use MySQL (relational db''s), but are there any
other options beside that and var_export/include? Something that works
in a similar way as MySQL when adding a new element without loading the
whole database itself...SQLite, PostgreSQL, Oracle, Microsoft SQL Server, ...
--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.17.14-mm-desktop-9mdvsmp, up 10 days, 18:31.]
Sharing Music with Apple iTunes
http://tobyinkster.co.uk/blog/2007/1...tunes-sharing/
I mean, I don''t mind using MySQL in itself, it''s just that I don''t
want use relational db''s.
I don''t know if it is possible to predefine the structures I''m using
in MySQL, because the number of levels varies etc.
Here is an example recording a single sequence of 6 elements:
How do I put this in a db?
array (
0 =>
array (
0 =2,
1 =>
array (
1 =>
array (
0 =1,
1 =>
array (
),
),
2 =>
array (
0 =1,
1 =>
array (
3 =>
array (
0 =1,
1 =>
array (
4 =>
array (
0 =1,
1 =>
array (
3 =>
array (
0 =1,
1 =>
array (
1 =>
array (
0 =1,
1 =>
array (
),
),
),
),
),
),
),
),
),
),
),
),
1 =>
array (
0 =2,
1 =>
array (
),
),
2 =>
array (
0 =1,
1 =>
array (
3 =>
array (
0 =1,
1 =>
array (
4 =>
array (
0 =1,
1 =>
array (
3 =>
array (
0 =1,
1 =>
array (
1 =>
array (
0 =1,
1 =>
array (
),
),
),
),
),
),
),
),
),
),
3 =>
array (
0 =2,
1 =>
array (
4 =>
array (
0 =1,
1 =>
array (
3 =>
array (
0 =1,
1 =>
array (
1 =>
array (
0 =1,
1 =>
array (
),
),
),
),
),
),
1 =>
array (
0 =1,
1 =>
array (
),
),
),
),
4 =>
array (
0 =1,
1 =>
array (
3 =>
array (
0 =1,
1 =>
array (
1 =>
array (
0 =1,
1 =>
array (
),
),
),
),
),
),
)
On 5 Des, 12:42, Toby A Inkster <usenet200...@tobyinkster.co.uk>
wrote:Mikhail Kovalev wrote:I''ve been adviced to use MySQL (relational db''s), but are there any
other options beside that and var_export/include? Something that works
in a similar way as MySQL when adding a new element without loading the
whole database itself...
SQLite, PostgreSQL, Oracle, Microsoft SQL Server, ...
--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.17.14-mm-desktop-9mdvsmp, up 10 days, 18:31.]
Sharing Music with Apple iTunes
http://tobyinkster.co.uk/blog/2007/1...tunes-sharing/
Mikhail Kovalev wrote:Hi.
I work with recursive array trees of 10-20 levels in PHP. So far I
have been using serialize() to store the arrays, generating files 5+
MB large, which take 10-15 seconds to unserialize and about tenfold of
RAM! I''ve been adviced to use MySQL (relational db''s), but are there
any other options beside that and var_export/include? Something that
works in a similar way as MySQL when adding a new element without
loading the whole database itself...
Thanks!
What do you mean by "without loading the whole database itself"?
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
这篇关于数据库建议的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!