by: lkrubner |
last post by:
Are there any benchmarks on how much an extra, unneeded VARCHAR, CHAR,
INT, BIGINT, TEXT or MEDIUMTEXT slows down a database call with MySql?
PostGre info would also be useful.
I'm trying to...
|
by: Mortrek |
last post by:
Hi.
We have a .NET programmer using our SQL server. The database is roughly
8GB at this point, full of all of our inventory, payroll data, etc. for
running reports.
This is on a dual-xeon...
|
by: Tommy |
last post by:
hi
I am new to SQL.I have database of 30GB.I have just heard about
spliting Databases which helps in Performance.So please can any one
guide me in what are the steps involved in it.
Anxious to...
|
by: nospammmer |
last post by:
Hello group,
I have a rather general but interesting inquiry that is related to PHP
and I hope this is the appropriate place to post it.
I'm looking for a way to improve dramatically the...
|
by: Stephen |
last post by:
Hello,
Is it normal for plain VACUUM on large table to degrade performance by over
9 times? My database becomes unusable when VACUUM runs. From reading
newsgroups, I thought VACUUM should only...
|
by: Gerald Khin |
last post by:
I encountered a performance problem with UPDATE statement and foreign
key constraints.
There are two tables involved: A parent table A and a child table B:
create table A(
ID CHAR(15) NOT...
|
by: Smutny30 |
last post by:
Hello,
I need to implement a solution where db2 Workgroup v. 8.1 is used for
storing quite huge amount of data. The data will be rarely read and searched
and those operations do not need to be...
|
by: James Conrad St.John Foreman |
last post by:
One of the larger tables in our database is now 6.8 million rows (1 per
financial transaction since 2000).
Every time an amendment is made to a booking, new rows are added to the
table for each...
|
by: salad |
last post by:
I have an A97 application that is NOT split on a network. It is used by
15+ folks continually. It is quick and fast.
I split it several years ago and had to merge it together again after
the...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|