| Pages: 1 2 3 4 [5] 6 7 8 9 10 11 12 13 .. 13 :: one page |
| Author |
Thread Statistics | Show CCP posts - 12 post(s) |
FireFoxx80
   |
Posted - 2006.01.30 12:43:00 -
[121]
Maybe a SQL techie can help this:
I run the SQL import scripts via Query Analyser, and they go in fine. Well all except the scripts that are over ~2MB, where I get an 'insufficient memory' error.
Query Analyser is being run on a different system to the SQL Server.
23? # Missile Tool # ex: P-TMC : USAC |
Gal'tashec
|
Posted - 2006.01.30 12:56:00 -
[122]
 Originally by: FireFoxx80
Maybe a SQL techie can help this:
I run the SQL import scripts via Query Analyser, and they go in fine. Well all except the scripts that are over ~2MB, where I get an 'insufficient memory' error.
Query Analyser is being run on a different system to the SQL Server.
Use the Import Data feature of the Enterprise Manager instead. I had the same problem as you but was able to import it without any problems
|
Gal'tashec
|
Posted - 2006.01.30 12:58:00 -
[123]
Originally by: t20
Originally by: Gal'tashec
Ayla Vanir,
I imported that table into a SQL Server 2000 database last night without any problems. Now to find out where I can find the cargo capacity of a ship 
dbo_invTypes > capacity
t20 - thanks! A bit puzzled as to why it wasnt included in with the other attributes and instead placed directly with the type itself?
|
FireFoxx80
|
Posted - 2006.01.30 16:58:00 -
[124]
Originally by: Gal'tashec
Originally by: FireFoxx80
Maybe a SQL techie can help this:
I run the SQL import scripts via Query Analyser, and they go in fine. Well all except the scripts that are over ~2MB, where I get an 'insufficient memory' error.
Query Analyser is being run on a different system to the SQL Server.
Use the Import Data feature of the Enterprise Manager instead. I had the same problem as you but was able to import it without any problems
Do you just import the CSV values into tables created with the CREATE TABLE defs in the SQL scripts?
23? # Missile Tool # ex: P-TMC : USAC |
Gigi Barbagrigia
|
Posted - 2006.01.31 04:58:00 -
[125]
Indexes:
Since data will be mostly (exclusively more likely) read only, you need not to hold back on their creation. First I would suggest identifing all fields you'll be using in JOINs. Afaik all are of integer type so not very disk space hungry. Next, try to draft your displays of data. Which columns will you use for sorting? And lastly, which char fields will be searchable.
-----
42 |
Gal'tashec
|
Posted - 2006.01.31 08:16:00 -
[126]
Originally by: FireFoxx80
Do you just import the CSV values into tables created with the CREATE TABLE defs in the SQL scripts?
In Enterprise Manager
[1] Create a new database
[2] Right-click it and select "All Tasks"
[3] Select "Import Data"
[4] Use the wizard to complete the import (one table at a time)
be sure to check the "First row has column names" and the seperator is semicolon.
Hope it helps
|
Jack Tau
|
Posted - 2006.01.31 09:17:00 -
[127]
Originally by: Gal'tashec
Originally by: FireFoxx80
Do you just import the CSV values into tables created with the CREATE TABLE defs in the SQL scripts?
In Enterprise Manager
[1] Create a new database
[2] Right-click it and select "All Tasks"
[3] Select "Import Data"
[4] Use the wizard to complete the import (one table at a time)
be sure to check the "First row has column names" and the seperator is semicolon.
Hope it helps
This is of course if your using the CSV export.. For the SQL Import, either get a better tool than QA(It's a bit old now :P) or if you insist on using it, replace all the blank lines with "GO" commands, and QA will batch it up for you. Assuming you didnt alter the default connection options in you QA settings.
Enkidu Production Manager
If you dont understand this sig, you need to get out less ;) |
Skyran
|
Posted - 2006.01.31 21:18:00 -
[128]
Originally by: Jack Tau
For the SQL Import, either get a better tool than QA(It's a bit old now :P)
Just out of curiosity, what would you recommend other than QA? It's served me well over the years, but if there's something better, I'd love to take a look at it. :)
--------------------------------------
Nope... no sig here... move along. |
Bedrock
|
Posted - 2006.01.31 21:19:00 -
[129]
just out of curiousity, besides the ones already mentioned, what other programs/databases are you people using for all this data? Thanks.
|
Jack Tau
|
Posted - 2006.02.01 00:04:00 -
[130]
Originally by: Bedrock
just out of curiousity, besides the ones already mentioned, what other programs/databases are you people using for all this data? Thanks.
Im using SQL Server 2005 and ASP.NET at the moment, as I'm re-building my site, but I was using MSSQL2000 and plain ASP. My website link is below, and its based on the data(Login with test:test)
Enkidu Production Manager
If you dont understand this sig, you need to get out less ;) |
Jack Tau
|
Posted - 2006.02.01 09:18:00 -
[131]
Originally by: Skyran
Originally by: Jack Tau
For the SQL Import, either get a better tool than QA(It's a bit old now :P)
Just out of curiosity, what would you recommend other than QA? It's served me well over the years, but if there's something better, I'd love to take a look at it. :)
Well I am currently using SpeedSQLIde Pro, but they were just bought out by Quest, who are now stopping all development :| So its a great little tool, but probably not good if you intend to use it for years. I've also just bought a license for SQL Manager 2005 by EMS, which is a slightly better tool(Allthough a lot more costly), but it does have MSSQL2005 support which I need now.
Enkidu Production Manager
If you dont understand this sig, you need to get out less ;) |
FireFoxx80
|
Posted - 2006.02.01 11:20:00 -
[132]
Yeah, could parse and batch the SQL using VB.NET I suppose, never thought of that.
23? # Missile Tool # ex: P-TMC : USAC |
Sulfiro Domonas
|
Posted - 2006.02.01 14:55:00 -
[133]
Originally by: t20
Originally by: Sulfiro Domonas
totally off-topic: t20 are you who I think you are? (ex (maybe still) FL.be - FL.net crew member  )
the very same 
I'm Watcher (ex FL.be) it's thank to you I started playing (that and speed :p) this game :)
|
Kaladr
|
Posted - 2006.02.02 00:35:00 -
[134]
Originally by: Bedrock
just out of curiousity, besides the ones already mentioned, what other programs/databases are you people using for all this data? Thanks.
PostgreSQL and Python of course.
----
EVE-Central.com Coss-Region Market Browser | Obsidian Technologies - Manufacturing and Logistics |
FireFoxx80
|
Posted - 2006.02.02 11:08:00 -
[135]
Originally by: Bedrock
just out of curiousity, besides the ones already mentioned, what other programs/databases are you people using for all this data? Thanks.
I use MS SQL 2003 server, with ASP/ASP.NET/PHP to use it.
23? # Missile Tool # ex: P-TMC : USAC |
Iavia
|
Posted - 2006.02.02 16:13:00 -
[136]
Thanks for the pointers.
I've used MySQl Browser (can't say enough good things about it) to index the primary and foreign keys.
One query that was 90 sec. unindexed is now just under a half of a sec.
I have one query with 5 joins, a Group by/count(distinct), 5 conditions, and 3 sorts, that also hits that monster mapDenormalize (360k+ rows) table, that comes back in 10 sec. on P4 2.6 gHz.
|
Ser Julian
|
Posted - 2006.02.03 00:01:00 -
[137]
I was looking to dbo_mapSolarsystems, and I wonder to what the fields 'hub', 'corridor', 'fringe', and 'border' refer.
Is it for a pathfinding algorithm ? Or is it something more trivial ? ^^
|
Bermag
|
Posted - 2006.02.03 13:49:00 -
[138]
Is the activity type description posted in the blog correct? When I look in materialsFor Activity tab it looks like activity id 6 and 7 is manufacturing and recycle.
|
Zoon
|
Posted - 2006.02.05 11:20:00 -
[139]
Originally by: Bedrock
just out of curiousity, besides the ones already mentioned, what other programs/databases are you people using for all this data? Thanks.
At the moment I'm using MySql (hey I can't afford MSSQL and I wouldn't dare run a Windows webserver, I've done that before, and its a nightmare) and ASP.Net ... although I am using ASP.Net via Mono and Apache 2 which is proving a little troublesome.
I've got a PHP book somewhere so I'll be going PHP/MySql as soon as I get some practice with it.
__________________________________
Are you a mission runner?
Have you tried our Agent Tool and Mission Guides? You should! |
Jack Tau
|
Posted - 2006.02.05 11:57:00 -
[140]
Originally by: Zoon
Originally by: Bedrock
just out of curiousity, besides the ones already mentioned, what other programs/databases are you people using for all this data? Thanks.
At the moment I'm using MySql (hey I can't afford MSSQL and I wouldn't dare run a Windows webserver, I've done that before, and its a nightmare) and ASP.Net ... although I am using ASP.Net via Mono and Apache 2 which is proving a little troublesome.
I've got a PHP book somewhere so I'll be going PHP/MySql as soon as I get some practice with it.
MSSQL is free :P The MSDE for 2000, or the express version for 2005. Ye there cut-down, but there still far superior to mySql.
Enkidu Production Manager
If you dont understand this sig, you need to get out less ;) |
Gal'tashec
|
Posted - 2006.02.05 13:54:00 -
[141]
Originally by: FireFoxx80
Originally by: Bedrock
just out of curiousity, besides the ones already mentioned, what other programs/databases are you people using for all this data? Thanks.
I use MS SQL 2003 server, with ASP/ASP.NET/PHP to use it.
You must be the only one in the entire world thats running MS SQL Server 2003, hehe the new version is called 2005 and the previous 2000.
|
Jack Tau
|
Posted - 2006.02.06 09:20:00 -
[142]
Originally by: Gal'tashec
Originally by: FireFoxx80
Originally by: Bedrock
just out of curiousity, besides the ones already mentioned, what other programs/databases are you people using for all this data? Thanks.
I use MS SQL 2003 server, with ASP/ASP.NET/PHP to use it.
You must be the only one in the entire world thats running MS SQL Server 2003, hehe the new version is called 2005 and the previous 2000.
Probably because theres no such thing as MSSQL2003 :P Its just 2000 installed on windows 2003 with a new logo.
Enkidu Production Manager
If you dont understand this sig, you need to get out less ;) |
Narusegawa Naru
|
Posted - 2006.02.10 10:30:00 -
[143]
Unfortunately these SQL exports are designed around MS-SQL (T-SQL) which is a shame. However I've imported mine to MySQL 4.11 by running a search and replace on "dbo." (the table owner shouldn't be prefixed anyway), and also on ".csv" as table names shouldn't contain special characters. And lastly there are 2 CREATE TABLE statements that have a value on UNKNOWN
CREATE TABLE dbo.dgmAttributeTypes(
attributeID UNKNOWN,
Change these to INTEGER and things work fine. Albeit MySQL can be VERY slow when using joins in your SQL so it's best to remember to create INDEX's on the ID columns using normal indexing logic, which if your even bothering to use these exports you should atleast know basic database administration and optimization.
|
res0nance
|
Posted - 2006.02.10 13:26:00 -
[144]
Holy **** this stuff takes a long time to add via a php interface / http socket  . Had to select bite sized chunks of 1200 records.
|
mikic
|
Posted - 2006.02.12 14:37:00 -
[145]
Hi,
in data_misc_sql.rar i'm wondering about the database schemes you use the dbo_eveNames.sql script should that really be:
CREATE TABLE dbo_eveNames( ... )
or did you mean
CREATE TABLE dbo.eveNames( ... )
and in dbo_invTypes.csv.sql:
CREATE TABLE dbo_invTypes.csv( ... )
i guess that should be
CREATE TABLE dbo.invTypes( ... )
HavPhun - Mikic
|
Takigama
|
Posted - 2006.02.12 17:05:00 -
[146]
Originally by: Bedrock
just out of curiousity, besides the ones already mentioned, what other programs/databases are you people using for all this data? Thanks.
i've been using it mostly with php/j2ee and postgress/mysql/oracle (btw, converting from mssql's rather evil and not very sql standards compliant types back to other dbs is quite horrid)
btw CCP, thank you from the bottom of my heart for doing an sql export!!! :D :D :D
|
Gal'tashec
|
Posted - 2006.02.13 13:57:00 -
[147]
Is CCP experimenting with NOS counter messures ?  I was looking at some of the export data and came across this by pure chanse
TEST garlic Small Nosferatu I Blueprint
Alucard I Kills Vampires Dead
Garlic I 1 Blueprint
'Helsing' Anti-Vampire I Kills Vampires Dead
Garlic I 2 Blueprint
'Blade' Vampire Hunter I Kills Vampires Dead
Garlic I 3 Blueprint
'Buffy' Vampire Slayer I Kills Vampires Dead
Garlic I 4 Blueprint
|
Hanns
|
Posted - 2006.02.15 05:35:00 -
[148]
Originally by: Gal'tashec
Is CCP experimenting with NOS counter messures ? I was looking at some of the export data and came across this by pure chanse
TEST garlic Small Nosferatu I Blueprint
Alucard I Kills Vampires Dead
Garlic I 1 Blueprint
'Helsing' Anti-Vampire I Kills Vampires Dead
Garlic I 2 Blueprint
'Blade' Vampire Hunter I Kills Vampires Dead
Garlic I 3 Blueprint
'Buffy' Vampire Slayer I Kills Vampires Dead
Garlic I 4 Blueprint
ROFL gotta love the DEV's sense of humor
Jacques 4tw - Hanns
I watched Hanns beat up Chuck Norris yesterday -zhuge liang
|
Gaiden Estoval
|
Posted - 2006.02.16 12:17:00 -
[149]
Sorry to be a pain, but can someone point me in the right place to look in the tables for the appropriate skills for an item?
|
Turiel Demon
|
Posted - 2006.02.16 12:52:00 -
[150]
Originally by: Hanns
Originally by: Gal'tashec
Is CCP experimenting with NOS counter messures ? I was looking at some of the export data and came across this by pure chanse
TEST garlic Small Nosferatu I Blueprint
Alucard I Kills Vampires Dead
Garlic I 1 Blueprint
'Helsing' Anti-Vampire I Kills Vampires Dead
Garlic I 2 Blueprint
'Blade' Vampire Hunter I Kills Vampires Dead
Garlic I 3 Blueprint
'Buffy' Vampire Slayer I Kills Vampires Dead
Garlic I 4 Blueprint
ROFL gotta love the DEV's sense of humor
I think that may just be Gal'tashec's sense of humour
----
nothing to see here, move along nicely now, is that a pink dread out there. aaww you just missed it -eris
It's not an Eidolon with 5 Basic Miner's on it, that's for certain.(FF04) ~kieron
No love for me? :'( - Wrangler
If you can't beat Eris, join her, hmmm that sounded so much better in my head - Cortes
Cuddles Eeyore. He's soooo cute and doesn't play EVE. perfect -eris
Eve-online Forum mods arn't Pokemon, you don't need to collect them all - Ductoris
Here's my autograph - now do I get some groupie lub? Jacques'
Don't be greedy :P -Capsicum |
| |
|
| Pages: 1 2 3 4 [5] 6 7 8 9 10 11 12 13 .. 13 :: one page |
| First page | Previous page | Next page | Last page |