Vex Star

Vex Star

Computers and Programming

Vex Star RSS Feed
 
 
 
 

Posts tagged database server

Looking for a fast way to compare two large databases

i have two mysql databases that are supposed to be relatively synched. One is the student database for my school (about 28,000 records), and the other is a Moodle database (about 33,000) which should contain a user account for each student.
The two databases share a few fields, the primary key being the student’s idnumber. [...]

October 29th, 2008 | Tags: , | Category: general | Leave a comment

SQL Server 2005 DBA’s? I has a question! It’s about Transaction Logs

I need to import a file with an application that has SQL Server as a database. Before I enabled Transaction Logs, I was able to import a 440 MB file pretty quickly, within 3 minutes. Now that I have Transaction Logs enabled, the same file takes about an hour to import, and it errors out [...]

October 13th, 2008 | Tags: , | Category: general | Leave a comment