SQL

Forum discussion tagged with SQL.
  1. Alexxx99

    Question Cant open huge sql file

    The size of sql file is 120gb. Notpad says that it's to big to open,notepad++ as well. I used Mysql Workbench,my pc started to use 10-11 gb of ram and 50% resaources of ssd.It took 5 minutes to get an error "Could not open the file.Could not allocate 0 bytes to read file "
  2. S

    [SOLVED] Export value from SQLite query to another js file

    Hello there, I am trying to make a discord bot that uses SQLite that stores user id. In order to keep code clean, I have made a file called db.js where I store all my db functions const sql = require('sqlite3') let db = new sql.Database('./userdb.db', sql.OPEN_READWRITE, (err) => { if (err)...
  3. N

    i5-8400 and 1050ti or just i7-8700 Office work.

    So my dad needs a new computer. He works mostly online and with PDF with maps and such. So should he get an i5-8400 with a 1050ti gpu. Or just use the integrated cpu in the i7-8700? Or maby just the i5? Would really appritiate some help on this :)
  4. J

    CPU Cooler Fan Direction

    Good day! I'm using a Deepcool gamaxx on a gigabyte b360 HD3 as a cooler for my i5-8400. The orignal location of the cpu fan is in the front and the direction of the airflow is inwards. Now I added another ram stick as an upgrade but the slot is being partially blocked by the cpu fan. It could...
  5. J

    Help with VGA LED stuck problem

    Hi. Im pretty sure that so many people has had this problem but im frustrated because i cant get my computer to turn on well My computer specs. AMD RYZEN 2700x Gigabyte ax370 gaming k5 Corsair vengance rgb 8gb 2666mhz Gtx 1060 3gb Im not sure if could be a problem of my power supply because...
  6. A

    Old GPU two 6 pin plugs, new GPU one 6 pin plug

    Hi, I have just installed a new gpu into my pc, the old gpu required two 6 pin plugs and my new one only has one 6 pin plug. When I plug in either of the plugs to the new gpu it gets power but the monitor shows no signal. I have also installed a new cpu and sshd at the same time. Gpu: ASUS...
  7. A

    PC bootlooping . Can be virus

    I recently tried to install a free cracked Photoshop through an installer from an unknown website . During installation I searched through the internet that photoshop CS3 takes a lot of time to get installed .I believed into that thing a I did a regretful mistake. I tried to quit the...
  8. T

    Please need help

    my laptop is asus x455l i try to open it but it stucks at preparing automatic repair it not continue its stuck for almost an hour please help.me
  9. T

    Looking for advice about gpus in a mini itx build

    Hello everyone currently looking at revising my build with the current pricing issues of gpus in the UK. I am going to be using as thermaltake v1 as my case of choice and am wondering about going for a 1060 instead of 1070 because the 1070s seem to be a little to expensive. The 1060 I am...
  10. B

    SSD as Main Storage, Any Problems Especially Lifespan?

    Hello, I have bought an SSD (500 gb) which is SanDisk Ultra3D, I'm using it as main storage and install everything like OS, apps, games, Adobe programs etc. and I reset to clean windows install nearly every 2 months. but I fear some people say SSDs wear out quickly every time you download/delete...
  11. E

    1 RGB Header Multiple RGB Compnents

    So I have the Asus Prime X-370 Pro and from what I can tell it only comes with one RGB header. I am currently using that for an rgb ssd sleigh but I want to add rgb case fans and a strip. How would I be able to do this while being able to keep the functionality of arua like blinking and other...
  12. M

    Every Game Stutters

    Hello everyone.First of all my english isn't great so i am sorry from now .Hope you're all doing great.I have i7 4790k With Hyper TX3 Evo,GTX 970 and 8GB Corsair Vengeance Pro 1600MHz ram.I don't have an SSD.My elder brother got 1050ti with Ryzen 5 1500x and 8GB ram without SSD too.He can play...
  13. A

    New Ryzen Build Wont Post?

    Ok guys so I build computers for people, thats how I get around. So presumably I know what Im doing... Just so that I dont get a million answers 'your 8 pin cpu connector' thanks. So here are my specs and the problem is below them: AMD Ryzen 1500x Asus PRIME-X370 AM4 EVGA NEX650G 1TB 7200RPM...
  14. T

    Alpine 700W good enough for my specs?

    These are my specs: CPU: i5 3330 RAM: 4gb corsair HDD: 500gb Seagate Mobo: ASUS P8H61-mx GPU: GT 210 (my new R7 250 1gb will be arriving in a few days) Case: Cooler master Elite 371 PSU: Alpine 700W I am fully aware that that PSU is bad but this computer has been running in an office for a...
  15. L

    Do i really need hyper threading on?

    I have a Intel Core i7 4790K but i'm not overclocking. My temps while playing CPU heavy games like Battlefield 1 are bouncing from 55-59 degrees celsius. If i turn hyper threading off what are the pros and cons? I'm really looking for it to cool my CPU even more but still have the same...
  16. BigJohnnyTwoToes

    Overclocking DDR4 3200 on Asus Z-170a with I7 6700k

    I am pretty sure i just read somewhere that the DDR4 3200 is overclocking ram, does that mean i have to overclock to use it, or that it can be overclocked to perform up to 3200? I obviously plan on overclocking since i got that motherboard/cpu combo, but I am new to custom pcs and wasnt planning...
  17. L

    PC Audio Jack Holes Broken

    My audio jack holes (recording and playback) are semi broken for my PC, In the past I bumped them both when there was a headset jack in them and it seemed to have stuffed them up. When I move both Audio and Recording jacks for my headset it makes a high pitched scream. I cant talk to people on...
  18. L

    New build or upgrade

    I need some input I am debating if I should upgrade parts or just build a new computer all together. CPU = Intel Core i5-3570K Ram = G.SKILL Ripjaws X Series 16GB ddr3 1600 GPU = EVGA GTX 670 FTW MB = ASRock Z77 Extreme6 LGA 1155 Intel Z77 Games I play. Witcher 3, Rainbow 6, Will be playing no...
  19. C

    pc fps problem

    first of all sorry if my thread its in the wrong category. I have a problem lately with my pc fps. my specs are cpu:amd fx-8350 gpu:760 gtx ram:8gb(2x4) ssd:850 evo 128gb hdd:1tb seagate barracuda i think ps:corsair gs600 cooler:not custom well the problem is that everygame i play it runs at...
  20. ravndal15

    Is my motherboard compatible with any of the processors from this website?

    Hello just wondering if my motherboard is compatible with any processor other then the LGA1155 sockets ? Especially from the following website ? It seems they have no LGA1155 socket types? Are they discontinued ? Thank you in advance Website buying from https://www.pccasegear.com Motherboard...
  21. slyverine

    asus z170 pro gaming + i76700k +hyper x predator 2400 not working together!

    Hello there. I recently purchased and assembled this build. Motherboard: asus z170 pro gaming RAM: KINGSTON Hyper x predator 2400 cpu: i7 6700k 4Ghz psu: corsair AX860 VGA: Asus nvidia 970 I assembled them with watercooling, tried to start the pc, but when i press the button the pc starts and...
  22. J

    MSI 750TI vs ASUS 750 TI

    Hey guys! I am purchasing a new graphics card and I am deciding between two GTX 750 TIs from different manufacturers, both coming to $89.99 after rebate. First is the MSI, boasting a slightly higher clock speed and military grade capacitors and Direct X 12 but only supports up to 3 monitors...
  23. P

    $1000 Gaming Build For Friend - no peripherals or OS needed

    So I'm building for a friend and so far it seems like an i5 and an upper end GPU would be good(970?) - I don't think there will be any overclocking or upgrading so I was thinking maybe I don't need a real expensive motherboard and also not sure on the PSU. -My friend has extra storage so i...
  24. G

    Changing motherboards with different chipset qithout reisntalling windows 8.1

    Well ,i just want to know if theres a way to upgrade my motherboard from a MSI H-81 to a MSI Sli krait MS-7922\Z97S,both of them are 1150 , so im keeping my Corei 5 4460. PD:Im using Windows 8.1 64bits
  25. T

    WiFi Extender vs Wireless Network Adapter

    Heys guys, i recently moved rooms in my house causing me to be quite far from the modem, and unable to remain using an ethernet cable. Just curious which would be better, a WiFi extender or a wireless network adapter for my PC The 2 I've been looking at are here(price isn't really an issue)...
  26. N

    Trying to add wireless speakers to bose wave

    I have a bose wave system and want to add some wireless speakers so I can hear the music in other parts of the house? Can anyone tell me if this is possible and what I would need?
  27. D

    Dual Monitors and a APU

    I do not currently have dedicated graphics card in my PC. Is it possible to have 2 monitors going without a dedicated graphics card? I just want this for work, not for gaming.
  28. KENDAWG2000

    WD Blue RAID-0 for Recording 1080p @60fps?

    Hello, I made a post here the other day, but figured I wasn't specific enough and I do not know if it will be seen by anymore people. I currently record to a 500gb secondary Toshiba HDD that I got with my CyberpowerPC. The drive has been good up until you try 1080p @60fps, it struggles reaching...
  29. A

    Looking to upgrade CPU and GPU

    Hello all, I'm looking to upgrade both my CPU and GPU for my computer. I pretty much exclusively play world of warcraft and am looking to increase my computers performance without spending tons of money. A good upgrade for both between 3 or 4 hundred total for both would be right around what I'm...
  30. bharathbigb

    Best GDDR5 GPU under 100$

    Hi all,Bharath here.I am from India.So eh... Every GPU is somewhat Costlier here.I am in need of a GDDR5 GPU under 100$ Oh and BTW,I use a Crap Zebronics 450w Local PSU which has one Molex free and NO PCI-e Power connector !! System Specs i5 2500K Stock Clock Intel DHC7CL SATA 3 PCI-e 2.0 USB...
  31. N

    BIOS wont recognize a new PNY SSD, however, Windows 8.1 CAN see it.

    Title says it all...I bought a new PNY SSD. Planned on putting the OS on it, and using the HDD as data storage. It's a HP Envy desktop bought just a few months ago, so it should read everything fine. I have tried multiple sata ports, and sata cables...any ideas as to why it cannot read it...
  32. V

    I have that same problem too :( Can somebody help us please???

    I have that same problem too :( Can somebody help us please???
  33. R

    Question regarding GTX770

    Hey guys, I got a GTX770 as a gift and im wondering if its safe to plug it into my pc as im told that the recommended power is 600w. Current specs are as below. :) Intel Core i5 3470 @ 3.20GHz ASRock B75M-DGS EVGA GTX 560 1GB G.Skill Value 1333Mhz 4GB x 1 500GB HDD FSP Raider 450W 80Plus Bronze
  34. K

    NVIDIA Driver Installation Trouble

    I have tried to install the latest NVIDIA Driver, version 337.88, with no luck. I have a GTX 750 TI video card. Please Help!
  35. W

    Watchdogs CPU upgrade

    I'm looking to upgrade my CPU and motherboard for Watchdogs I currently have the X4 955 Black edition and am looking either the fx-8320 or the i5-4670k (or 4690) Obviously the AMD route is cheaper, and I've read the newer games can take advantage of more threads, but still unsure, so any help...
  36. B

    Computer Boots but No Display

    Hi, I recently had an error message while using my PC along the lines of "system recovered from nVidia graphics failure." Meanwhile, I was getting pixellation and screen blips. Then my computer would reboot. After a few instances of this my PC now boots (I get a beep) but I get absolutely no...
  37. M

    lightwave lw-utv combo

    driver for win 7 & 8
  38. Achint2000

    Games slow down then speed up from time to time!

    I didn't make ANY changes at all to my computer and it's still as a rock. THE DAMN PROBLEM:- ----------------------------- If I run ANY game (or program) which requires a little high-end work, frames drop every 3-5 seconds to 1 FPS from 60 FPS and then reach back to 60 FPS and with the GPU...
  39. S

    Background static sound I can't get rid off.

    Basically I have a static sound that I can't get rid of. I hear it as soon as windows boots. There is no visible audio from the playback tab in sound options. I hear it without the mic plugged in and in both my motherbaord audio out in the back and my case audio out in the front. And last...
  40. L

    Antec Kuhler H2O 620

    Anyone have any feedback or suggestion about cooling system Antec Kuhler H2O 620 to make OverClock