VLDB is the acronym for very large database (>1TByte of data)
Questions tagged [vldb]
20 questions
0
votes
3 answers
Impact of ALTERING column in enormous table NOT NULL to NULL
SQL Server 2005:
240 million row table.
Column requirements changing from NOT NULL to NULL.
Generally bad practice (and often impossible) to use ALTER statements when dealing with tables this big, however, trying to avoid rebuilding the table, if…
user24531
- 226
- 2
- 5
0
votes
1 answer
query optimization in VLDB
i have a very large database, with size upto around 2 gb.
the database contains 10 tables and one of the tables has over 60 columns and 13902134 rows
(vt_owner)
Insert into insurance.uninsured_vehicle
select…
Varun Gupta
- 1
- 2
0
votes
2 answers
Oracle tables with > 10B rows
What's your experience with querying Oracle tables with >10B rows? The tables are well partitioned
Can this be done using "noraml" machines (clustered) or - does it require a gigantic machine?
Thanks!
user1042960
- 21
- 3
0
votes
3 answers
PHP + MySQL good for VLDB
I am developing two web-sites having - one having few tables and the other having over 50 tables. I am using PHP and MySQL.
Some of the tables of both the web-sites are expected to receive well over a hundred-thousand rows every year. I have read…
Kumar Kush
- 2,495
- 11
- 32
- 42
-1
votes
1 answer
How to optimize the performance of a very large MySQL database?
I am working on a web-application in PHP-MySQL. I am MySQLi API for database access. I have broadly two questions:
How can I increase the performance of the MySQL database?
How much secure and suitable is MySQL for large, enterprise level…
Kumar Kush
- 2,495
- 11
- 32
- 42